invalid MySQL result

YodaOfCamarilla

hi i got the error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp\www\main.php on line 1637

the source is:

$sql="select * from rank where vacation=\"no\" and deleted=\"no\" and lastlog<=\"$actualdeletetrainertime\" order by lastlog";
$rs=mysql_query($sql,$conn) or die("Err:QueDeleteTrainer1");
while($row=mysql_fetch_array($rs))

I cant find what is wrong and there doesnt appear to be any errors with what i want it to do 🙁 it just looks messy.

dalecosp

echo the value of $rs ... see what's wrong!

LordShryku

Change this

$rs=mysql_query($sql,$conn) or die("Err:QueDeleteTrainer1");

to this

$rs=mysql_query($sql,$conn) or die(mysql_error());

That'll tell you what's wrong. Probably an error in the SQL.

YodaOfCamarilla

i echoed it and got the message:

Resource id #37

dalecosp

Well, if you've done what LordS suggested and got no hints, I can't give you one, I don't think.

$rs looks valid. I guess you could turn down your error reporting!! 😉

YodaOfCamarilla

thx for the help guys, i managed to fix it by randomly moving lines of script about 😛

I think it was because i had loads of lines contained within the while function, as soon as i took it out by adding in a pointless if function it fixed it 🙂 thanks again.

dalecosp

Well, that certainly sounds mystical enough for you to call yourself "Yoda ...."

The $4ce is strong with this one, heh...