 Help Needed With MySQL_fetch-array() Error |
|
|
|
|
  |
  Jun 11 2005, 03:07 PM
Post
#1
|
|
|
Member [ Level 1 ]  Group: Members Posts: 36 Joined: 10-June 05 From: London Member No.: 6,063  |
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.
This post has been edited by microscopic^earthling: Jun 11 2005, 04:39 PM |
 |
 
|
|
Jun 11 2005, 04:00 PM
Post
#2
|
|
|
PsYcheDeLiC dR3aMeR  Group: Admin Posts: 2,242 Joined: 29-January 05 From: Nakorn Chaisri, Thailand Member No.: 2,411 myCENTs:84.36 |
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 |
|
|
|
|
Jun 11 2005, 11:47 PM
Post
#3
|
|
|
Premium Member Group: Members Posts: 352 Joined: 2-March 05 From: Australia Member No.: 2,859 |
QUOTE(Cookiemonster @ Jun 12 2005, 02:07 AM) 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... |
|
|
|
|
Jun 13 2005, 12:04 AM
Post
#4
|
|
|
Advanced Member Group: Members Posts: 145 Joined: 13-December 04 Member No.: 1,734 |
did you send a query to mysql_fetch_array() ?
description; QUOTE 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... |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 23rd November 2008 - 05:18 PM |