if statement not working properly

Duskwalker

Hi, I am working on a script that checks to see if you have a certain piece of equipment, and if you have 1 or more it will list them and their options, or if you dont have it, it will simply just not show you anything. There seems to be a problem with it, because it isnt showing me anything and i have the piece of equipment it requires.

<?

$torch = mysql_query("select * from equipment where type=Light and owner=$stat[id]");

if (!empty ($torch[id])) {



print "<b>Lights</b><table>

<tr><td class=tbody width=50><b><u>Name</td><td class=tbody width=100><b><u>Desc</td><td class=tbody><b><u>Options</td></tr>";

$esel = mysql_query("select * from equipment where type='Light' and owner=$stat[id]");
	while (	$equip = mysql_fetch_array($torch)) {
		print "<tr> 


 <td class=tbody><a href=\"item.php?view=".$equip['id']."\"><img src=\"images/items/".$equip['name'].".png\" border=0></a></td> 
     <td class=tbody><b>".$equip['name']."</b> <br>".$desc[$equip['name']]."<br>Uses: $equip[more] </td> 

     <td class=tbody><a href=\"item.php?drop=$equip[id]\">Drop</a></td> 

   </tr>";
}
	print "</table>";



} else {
	print "";
	}



?>

Thanks alot for taking a look at this.

dalecosp

One guess:

Watch that you don't put bracket indices in parsed syntax. (IE,

$sql="select foo from bar where baz=$qux[$something]";

//should instead be

$sql="select foo from bar where baz=".$qux[$something];

I'm also curious about your first two lines. In calling $torch=mysql_query, you're setting a string, which is not the same as an array. So, how can you call "if not empty $torch[id]"??

Sorry my brain's not working...been on the phone with the Telco for over an hour :mad:

Duskwalker

Oh, hmm.

I am setting a string, but i referenced it like its an array. hmm

   $torch = mysql_query("select * from equipment where type=Light and owner=$stat[id]"); 

if (!empty ($torch[id])) {

Ok, I want it to get all the table entries that meet those two requirements, and then I want that second like to be if....

If it comes up with at least one entry

how would i do that?

-Dusk

dalecosp

if ($torch)

should get it ... the query will return false otherwise....