Jake Posted January 7, 2007 Share Posted January 7, 2007 I am making a big report system, but for some reason i am getting this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/thelib/public_html/bugreport.php on line 45 These are the lines: else { $q=mysql_query("SELECT * FROM bugreport WHERE '{$_GET['ID']}'==bugid ORDER BY bugid ASC",$c); $r=mysql_fetch_array($q); Help please! Quote Link to comment Share on other sites More sharing options...
seanybob Posted January 7, 2007 Share Posted January 7, 2007 Re: MySQL fetch array theres a working bug report system somewhere on these boards... looking at that code you posted, only thing that i can see that may be a prob is this '{$_GET['ID']}'==bugid switch it around bugid=='{$_GET['ID']}' Quote Link to comment Share on other sites More sharing options...
Revolution Posted January 7, 2007 Share Posted January 7, 2007 Re: MySQL fetch array ...and you only need 1 = not 2 (==) Quote Link to comment Share on other sites More sharing options...
seanybob Posted January 7, 2007 Share Posted January 7, 2007 Re: MySQL fetch array ...and you only need 1 = not 2 (==) doh! missed that ;P Quote Link to comment Share on other sites More sharing options...
Decepti0n Posted January 8, 2007 Share Posted January 8, 2007 Re: MySQL fetch array delete the ,$c when will people learn that you don't need it :( Quote Link to comment Share on other sites More sharing options...
Jake Posted January 8, 2007 Author Share Posted January 8, 2007 Re: MySQL fetch array Ok thanks, will try that. Do you not need the $c? O its on all of the files i downloaded with it, so i just leave it on. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.