Re: Extracting random rows

Hello, works for me. As a workaround you can pass a random integer to te RAND() function to be used as seed value. Scott wrote:

Hello, Below is a boiled-down example of the problem I'm having. I'm trying to extract rows randomly from MySql, but I keep getting the same one. It works if I query MySql directly from the command line, so it seems like a php problem. Thanks, Scott <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN"> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <meta name="GENERATOR" content="Quanta Plus"> </head> <body> <? include ("connectlpi.php"); $sql = " select id from $table_name order by rand() limit 1 "; $result = @mysql_query($sql,$connection) or die("Couldn't execute query."); while ($row = mysql_fetch_array($result)) { $id = $row['id']; } echo "$id"; ?> </body> </html>