random row

[John Taylor-Johnston <John.Taylor-Johnston@xxxxxxxxxxxxxxxxxxxxx>]

My question is simnple. I want to randomly select a row in a mysql 
table. I have a primary id.

<?php
$server = "localhost";
$user = "foo";
$pass = "foo";
$db="foo_db";
$table="foo_table";
$myconnection = mysql_connect($server,$user,$pass);
mysql_select_db($db,$myconnection);

$sql = ??;

$news = mysql_query($sql) or die(print "<font 
color=red>".mysql_error()."</font>");
   while ($mydata = mysql_fetch_object($news))
   {
??
   }
?>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php