[RESOLVED] If(And)

Beffic

Ok so I was curious how I could fix this little scripting problem. Whenever I have the pickaxe equipped it still says that i need to equip it. Im not sure if it's because of the "AND" or what....

$ItemQuery="SELECT * from Items where Owner='$Player'";
$ItemQuery2=mysql_query($ItemQuery) or die("Could not get user stats");
$Item=mysql_fetch_array($ItemQuery2);

 if($Item['Name']=="Rusted Pickaxe" AND $Item['Equipped']=="yes"){
}else{
echo"You need to equip the Pickaxe first.";
}

NogDog

I'd start by doing a vardump() of $Item after you populate it and make sure the index names and the values are what you are expecting.

Beffic

Yeah, I'm still stuck... any other ideas?

NogDog

Can you show the output of that vardump()?

Beffic

vardump()?

NogDog

[man]var_dump/man (I forgot the undersore.)

Beffic

Yeah.... I don't have that in the script....

NogDog

I am suggesting that you add a var_dump($Item); after the mysql_fetch_array() command so that you can see exactly what the result row data looks like. This is just to help debug what the problem is.

Beffic

Oh ok, I can see how this could help. Thanks

Beffic

Thanks soooo much. It fixed my problem =D