Warning: Mysql_fetch_array(): Supplied Argument Is Not A Valid MySQL Result

Warning: Mysql_fetch_array(): Supplied Argument Is Not A Valid MySQL Result [ Visit Post ]

I am getting the following error on my php script: [code:1:085b4c6585]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/titles.php on line 42[/code:1:085b4c6585] This is line 42: [code:1:085b4c6585] Line 38 $sql = "select titleid from pages where sid=$catid"; Line 39 $result = mysql_query($sql ,$db); Line 40 if ($result) { Line 41 Lin ..... Read More

Comments by: PIper

Fri, 02 Jan 2009 00:35:10 -0700

i love this wallpaper... its mine on my computer!! =d

Comments by: pinguin

Fri, 02 Jan 2009 00:35:10 -0700

Basically this error is telling you that mysql could not find the data from the database. This is the problem: you are telling the database: Grab the data from the "titleid" table where the field "sid" matches whatever value $catid has in the pages table of your database. So simply put, you are getting this error because not matches were found. Either because the table or field is empty or you may have the $catid variable as empty (false) To resolve this problem, check to make sure your database has data that matches the $catid