[SOLVED] if($check == 1) help

[chinclub]

I am writing a script where I want it to check for several items in the database.  If any one of those items isn't there I want it to give an error.  If all items are there I was it to go to the next page.

 

I have done one step checks before but never multiple.  I have it set like this:

 

$check = mysql_num_rows(mysql_query("SELECT * FROM `items` WHERE `user`='{$_COOKIE['ipets']}' AND `name`='baby safe cage' AND `equipped`='1'"));
$checkaid = mysql_num_rows(mysql_query("SELECT * FROM `items` WHERE `user`='{$_COOKIE['ipets']}' AND `name`='first aid kit' AND `equipped`='1'"));
$checksup = mysql_num_rows(mysql_query("SELECT * FROM `items` WHERE `user`='{$_COOKIE['ipets']}' AND `name`='Supplement kit' AND `equipped`='1'"));
$checksvet = mysql_num_rows(mysql_query("SELECT * FROM `items` WHERE `user`='{$_COOKIE['ipets']}' AND `name`='vet directory' AND `equipped`='1'"));	

 

but I am not sure how to write the next line.  Would I write all checks together like this:

 

if($check == 1 && $checkaid == 1 && $checksup == 1 && $checksvet == 1)

 

or am I totally wrong all together on this?

[chigley]

Yes your if statement looks fine, why not try it before asking!?

[per1os]

Why use 4 separate queries?

 

<?php
$check = mysql_num_rows(mysql_query("SELECT * FROM `items` WHERE `user`='{$_COOKIE['ipets']}' AND `name` IN('baby safe cage','first aid kit','Supplement kit','vet directory')  AND `equipped`='1'"));

if ($check < 1) {
   die('None of the items were found');
}else {
   echo 'Yay we found ' . $check . ' number of items!!!';
}
?>

[chinclub]

Thanks