Retrieving specific row

bluefrog33

If I have the following:

$query = "SELECT * FROM table WHERE status='Open' ORDER BY rand()";
$result = mysql_query($query) or die(mysql_error());

I want "$row1" to represent a "fetch array" of the first row of this table generated randomly, "$row2" a "fetch array" of the second row of the same table, and "$row3" a "fetch array" of the third row.

I guess it would require less load time to limit the table generation to 3 entries, but I don't know...

Please help!

Thanks.

bradgrafelman

If you only want 3 rows, then yes, you should definitely add a LIMIT clause to your query so that the SQL server only has to worry about 3 rows.

I've moved this thread to the Database forum; you should read the sticky in this forum regarding the "ORDER BY RAND()" pitfall. In addition, you shouldn't use a "SELECT *" - instead, only select the columns that you actually need data from.

Finally, to retrieve three rows, just call [man]mysql_fetch_assoc/man three times in succession - it'll move through the result set after each time you call it.