mysql fetch object problem

[lengman]

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/igweeccr/public_html/includes/functions.php on line 212

 

I'm very new to PHP and am in need for some help... this is the code..

 

$drop =mysql_query("SELECT * FROM casinos");

while($tard=mysql_fetch_object($drop)){
$per = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$tard->owner'"));
if ($per->status == "Dead" || $per->status == "Banned"){
mysql_query("UPDATE casinos SET owner='0' WHERE casino='$tard->casino' AND owner='$tard->owner'");
}

}
$drop_bar =mysql_query("SELECT * FROM bar");
while($tard_bar=mysql_fetch_object($drop_bar)){
$per_bar = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$tard_bar->owner'"));
if ($per_bar->status == "Dead" || $per_bar->status == "Banned"){
mysql_query("UPDATE bar SET owner='0' WHERE owner='$tard_bar->owner'");
}

 

Could the problem be with the database, basically this part of the code is a feature on my game... a bar script.... My friend uploaded all the data onto the database, but I can't find the bar on the database... Me and my friend wrote this code, so I don't need to go to the third party thread.

 

Thanks for the help in advance.

 

P.S Line 212 =

while($tard_bar=mysql_fetch_object($drop_bar)){

[Mchl]

Change

 

$drop_bar =mysql_query("SELECT * FROM bar");

 

to

 

$drop_bar =mysql_query("SELECT * FROM bar") or die(mysql_error());

 

and tell us what error it gives then.

[lengman]

It's not changed anything at all.... Still:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/igweeccr/public_html/includes/functions.php on line 212

 

Thanks for helping me too.

[lengman]

I know the coding's poor too. Even though it is poor though, as far as I'm aware it should be working fine 

[redarrow]

please use this link to see the format ur using might be wrong..

 

http://uk.php.net/mysql_fetch_object

[lengman]

As far as I'm aware of and can see, it's definitely the correct

[Mchl]

I've gut this feeling...

 

Change:

$per_bar = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$tard_bar->owner'"));

 

to

 

$result = mysql_query("SELECT * FROM users WHERE username='$tard_bar->owner'") or die(mysql_error);
$per_bar = mysql_fetch_object($result);

[lengman]

aaaaaa... Still giving the same error, I just honestly can't figure it out for the life of me ???

[Mchl]

Neither can I ???

 

You sure this is the line 212?

[lengman]

Yeah, Line 212 =

$drop_bar =mysql_query("SELECT * FROM bar") or die(mysql_error());

 

but the fetch object is line 213:

while($tard_bar=mysql_fetch_object($drop_bar)){

 

 

I really can't figure it out.

[lengman]

..

[Andy-H]

BTM scripts are crap, add me on msn I will give you some (slightly) better ones I coded a while back

 

andy-holland@live.co.uk