[SOLVED] Random Row

[joecooper]

Which command can i use which will return a random row from mysql?

 

At the moment, this will return the lastest added row with ID as DESC:

 

$sql=mysql_query('SELECT * FROM wallpapers ORDER BY ID DESC LIMIT 1');

 

but i need just a random row from it

[lemmin]

You can use PHP's random function and use the number as a row id.

 

$sql=mysql_query("SELECT * FROM wallpapers WHERE ID = " . rand(min, max));

[joecooper]

ah, the min and max is what i cant enter. they are updated all the time so i cant exactly keep check on how many rows there are. i COULD how ever use the min as 0, and max as the ID number, but again when rows are deleted...

[joecooper]

for those who may be looking for answer for this:

 

use ORDER BY RAND()

[teng84]

you answer your question LOL so mark it solved