PHP: Generate Random Record

gistfile1

<?
// define your query

$your_query = "SELECT * FROM yourtable WHERE match1=\'yes\' AND match2<>\'yes\' AND ondate >=".date("Ymd")."";

// count the number of rows returned that match the query

$rowcnt = mysql_num_rows(mysql_query($your_query));

// generate a random number between 0 and the number of rows found (always -1)

$randvar = rand (0,$rowcnt-1);

// get the random record (in this case 1) by using the LIMIT statement which uses the record number generated in $randvar

$your_result = mysql_fetch_array(mysql_query("SELECT * FROM yourtable WHERE match1=\'yes\' AND match2<>\'yes\' AND date >=".date("Ymd")." LIMIT  ".$randvar.", 1"));

if ($your_result) {   // check if there is a result

if so, here comes whatever you intend to do with the random record,

echo $your_result["field"];
}
?>