How to alter for random record?

[timsharpe]

query = "SELECT * FROM autos WHERE category = 'autos'";");
$result = mysql_db_query ("autos", $query);
if($result) {
  while ($row = mysql_fetch_array($result)) {
    print $row["category"];
  }//while
}//
else{
  echo mysql_errno().": ".mysql_error()."<BR>";
}

mysql_close ();
?>

How do I alter the above script so that it will pick a random record?

Tim

[Volvagia]

Just slip ORDER BY RAND() in before a LIMIT 0,10 clause.

$query = "SELECT * FROM autos WHERE category = 'autos' ORDER BY RAND() LIMIT 0,10"