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>
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
