query not working

[Anon]

Can anyone think of why this code wouldn't work?

$result=mysql_query($query);

while ($query_data=mysql_fetch_array($result)) {

I keep getting this error:
Warning: Supplied argument is not a valid MySQL result resource in /usr/local/etc/apache_1.3.12/htdocs/test/rfatest/rfadisplay.php on line 52

BTW, line 52 is the line above beginning with 'while'

thanks,
MT

[Anon]

The query is probably wrong, try using this after $result = ...

print mysql_error();
print mysql_errno();

this will give you the mysql error if it exists, and you can then redefine your query to make it work.