If you have MySQL ver >= 3.23.3, you can do this:
SELECT ...., RAND() as rand_col FROM ... ORDER BY rand_col
if you have a previous MySQL ver, or your DB program doesnt support such a method, you could do it in PHP with something like this:
$result = mysql_query("SELECT ....");
while($record = mysql_fetch_object($result)){
do{
$rand = rand(1,100000);
}while($recordArray[$rand]);
$recordArray[$rand] = $record;
}
ksort($recordArray);
while(list($key,$val) = each($recordArray)){
do something with your results.
}
