MySQL fetch array

[Jake]

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!

[seanybob]

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']}'

[Revolution]

Re: MySQL fetch array

...and you only need 1 = not 2 (==)

[seanybob]

Re: MySQL fetch array

 

...and you only need 1 = not 2 (==)

doh! missed that ;P

[Decepti0n]

Re: MySQL fetch array

delete the ,$c

when will people learn that you don't need it :(

[Jake]

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.