Displaying Single Rows?

How would I display a single item from a single row in PHP? Currently for an array of many rows, I have:

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){

$result = mysql_query($query) or die("Could not store game info in database results.");

echo '<option value="'.$row['codename'].'">'.$row['gamename'].'</option>';

and then

'.$row['codename'].' to display a row

But I just want to display one thing at a time.

not quite sure what you are trying to do, but I would rewrite the query to produce only one record by setting some criteria...

$sql = "select * from table where id = $rowid";

hth

Ok, say you have a table like this:

|row1 | row2 |

how would I pull out data from the entry 1 row and display its information. Only that one row, nothing else. 😕

Use mysql_fetch_assoc instead of mysql_fetch_array.
Uhm... skip the while loop, then you'll get just ONE row.

another way to do that is by using LIMIT
The following will do the same thing:

$sql="select * from table order by id limit 1";

However, where clause should be the best since it queries only one specific row which does not necessarily be the first one.