random records but sometimes comes no result

[teddmcload]

i am using that codes while getting random records from mysql database.

$numofrecords = mysql_db_query($dbasename, "select count(*) from winner");
$randomacc = rand(0,$numofrecords-1);
$query = "SELECT winnerid, title FROM winner LIMIT " . $randomacc . ",1";
$result=mysql_db_query($dbasename, $query);
$row = mysql_fetch_array($result);

but sometimes no result shows. you have better codes to get random record?

[laserlight]

could try:

$query = "SELECT winnerid, title FROM winner ORDER BY RAND() LIMIT 1";
$result=mysql_db_query($dbasename, $query);
$row = mysql_fetch_array($result);

you may have to seed RAND() though, perhaps by using RAND(NOW())

[teddmcload]

thank you 🙂