Suddenly a mysql warning..?

[Anon]

OK, I've been writing PHP for a little while now, and I've used the
following line of code several times...

while ($row = mysql_fetch_array ($result))

which normally iterates through a loop and allows me to pull values,
etc, however now for some reason I am receiving a warning on that
line...

Warning: Supplied argument is not a valid MySQL result resource in
/export/home/other/www/test/group/group.php on line 80

Does anyone know what causes this error, in case you need it, the code
for the result can be...

$query = "select * from $name where date = '$date'";
$result = mysql_query($query);
while ($row = mysql_fetch_array ($result))

or anything similar...Any ideas?

Wyatt McGuire

[Anon]

The query itself seems to be failing for some reason - $result gets the value FALSE and mysql_fetch_array() doesn't like being asked to fetch from FALSE.

Slip in an echo $query just before the mysql_query() and see just what MySQL is being asked to do.

[Anon]

HEY THANKS!!!!

Turns out I was trying to select * from "" because I hadn't declared my $name variable global. Thanks again

Wyatt McGuire