RSS

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resou

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

•

Join Date: Apr 2005

Location: Auckland, New Zealand

Posts: 136

Reputation: sarahk is an unknown quantity at this point

Rep Power: 4

Solved Threads: 1

sarahk

Offline

Junior Poster

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resou

Oct 17th, 2005

It's probably not a php version problem

usually $sql and $query are the same thing and you use $result for the result set. That improves readability but doesn't fix anything

Help with Code Tags

(Toggle Plain Text)

$result = mysql_query($query) or die(mysql_error() . '<br />'. $query);
     
while($row = mysql_fetch_array($result)){
 var_dump($row);
}

this should show where the problem is.

If it's the query paste it into phpMyAdmin and see the errors there. It may be something simple like a missed quote mark or a column in the table.

Sarah

Vote for DaniWeb
Sarah's SEO Blog

DaniWeb Home > Forums > Web Development > PHP > Warning:...

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resou

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resou