How do I grab all the data from a single row in mysql?

Corpheous

What I'm doing is randomizing some numbers (1 to 100 for example) and then doing a query based on the outcome of those numbers (lets say 1-75 = "Common", 76-100 = "Uncommon" for simplicity).

Now that I have these, I find the number of rows in my query (lets say there are 5 rows returned for the results of the query). Now I take that number and do this:

$number_stuff = rand(1, $number_of_rows);

Now that I have THAT number I want to go back and do another query where I select that specific row's information. Unfortunately this is the part I don't know how to do. At the very least I want to grab my primary key field, which is a unique number to each row, from the specific row. At most I want to grab all the information from this random row.

cbj4074

This will fetch the row that contains a field match for 'some value' (which would be your key), order the fields by date, and store the results in the array $whole_row, through which you can iterate to extract the information:

$query="SELECT * FROM yourtable WHERE somefield = 'some value' ORDER BY `date` DESC"; //select the all matching entries from the table
$result = mysql_db_query($dbname, $query2) or die("The following query failed: " . $query2); //do the query
$whole_row = mysql_fetch_array($result);

That help?

Gez Lemon of JuicyStudio writes some nice tutorials for beginners at PHP and MYSQL. Check 'em out: http://www.juicystudio.com/tutorial/php/mysql.asp

swr

It seems you want to do a SELECT and get the Nth result. You can do that using LIMIT.

select * from table order by name limit $n, 1

That will give you the row number $n (zero being the first).