[SOLVED] mysql_fetch_array() error

[forumnz]

Heres my code which is supposed to select a random row from a db.

 

<?php
include('connectdb.php');

$result = mysql_query("SELECT * FROM fflists ORDER BY RAND () LIMIT 1");
while($row = mysql_fetch_array($result))
  {
  $business_name = $row['business_name'];
  echo $business_name;
  }
?>

 

And the error:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/www/vhosts/foodfinder.co.nz/httpdocs/rowtest.php on line 5

 

Thanks, Sam.

[freebsdntu]

I guess it means your resultset is empty,try to debug on that.

By the way,is that all the code? If yes,you have to connect to your database first before any operations on it.

[revraz]

$result = mysql_query("SELECT * FROM fflists ORDER BY RAND () LIMIT 1") or die (mysql_error());

 

Your query is failing, the error will show you why.

[forumnz]

Here is the error:

FUNCTION foodfinder.RAND does not exist

 

What does it mean?

Sam.

[forumnz]

Should be RAND() not RAND ()

 

Thanks!