Mysql PHP help with Mysql_fetch_array(); ..?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/Sitename/public_html/page2.php on line 34 The line 34 is: ## $aa = "SELECT * FROM useraccounts"; $res = mysql_query($aa); while($in = mysql_fetch_array($res)){ ## and then I'm just echoing the... show more Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/Sitename/public_html/page2.php on line 34

The line 34 is:

##
$aa = "SELECT * FROM useraccounts";
$res = mysql_query($aa);
while($in = mysql_fetch_array($res)){
##

and then I'm just echoing the output, I keep getting this same error on my actual live server for some reason and Mysql_fetch_array works fine on other pages.. I don't know really :(

Anyway any help would be great,
Thanks,
R
2 answers 2