Help Needed With MySQL_fetch-array() Error

[Cookiemonster1405241499 0]

databasing is quiet hard to learn but im starting to get the hang of it. on my home page i have a few errors like this Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mrogers/public_html/html/nav.php on line 80 i have checked whats on line 80 and this is what i ended up with$row = mysql_fetch_array($sql);but it does not look like anything is wrong and i kind of do not under stand the mysql witch i am learning at the moment, but any one know what the problem is please tell me. need any more info like the whole .nav file just ask me.

Notice from m^e:

Try and keep your topic title as relevant to the message body as possible - in general try and include some unique keywords that appear in the message body and compose a title, that best summarizes your post. This will help it get better responses as well as show up on search engines real quick. Topic edited.

Edited June 11, 2005 by microscopic^earthling (see edit history)

[miCRoSCoPiC^eaRthLinG 0]

Unless you post the whole block of code, it won't be possible to figure out the cause of this error alone from that single line. Such an error message could be because of a wide variety of reasons - missed out closing braces, incorrect table names (MySQL tables are extremely case-sensitive)... so post the whole block of code here and we might be able to help you out.Regards,m^e

[jedipi 0]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mrogers/public_html/html/nav.php on line 80
i have checked whats on line 80 and this is what i ended up with

$row = mysql_fetch_array($sql);

Just like microscopic^earthling said, this error happens dur to a wide variety of reasons. If you post your nav.php here, it would be helpful.

However, you can check the code before line 80. $sql may not have any value.
and you can always use 'echo' for debug...

[whafizi 0]

did you send a query to mysql_fetch_array() ?

description;

mysql_fetch_array(PHP 3, PHP 4 )

mysql_fetch_array --  Fetch a result row as an associative array, a numeric array, or both.
Description
array mysql_fetch_array ( resource result [, int result_type])


Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.

sorry if i got you wrong...