SQL error

[StanleyDev]

im making a lottery system and im getting this error:

mysql_fetch_object(): supplied argument is not a valid MySQL result resource

the line thats causing it is:

$credits = mysql_query("SELECT * FROM users WHERE `id` = '$id'");
                  $row = mysql_fetch_object($credits); << this is the actual line im getting the error from.
                  $credits = $row->credits;

any ideas whats casuing it?

 

[Kryptos]

Mhm.. I see nothing wrong with it ( Maybe the id (field) having -> ' <- (Don't really think that's it.)
Only thing, make sure $id has a value I.E: 1

 

[StanleyDev]

Mhm.. I see nothing wrong with it ( Maybe the id (field) having -> ' <- (Don't really think that's it.)
Only thing, make sure $id has a value I.E: 1

it wasnt the " ' ", and by giving $id a value did you mean like in the db or.....?

 

[Kryptos]

With that, I mean:

$id = 1;
 
//Query here.

 

[StanleyDev]

With that, I mean:

$id = 1;
 
//Query here.

ill try that thanks (hopefully it works) whoooo thanks sooo much