using more that 2 conditions to obtain info from db
| From: | Earl Clare | Date: | Thu, 26 Sep 2002 07:59:26 +0000 |
| Subject: | using more that 2 conditions to obtain info from db | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21994@lists.php.net to get a copy of this message | ||
hi everyone,
I am new to all php and mySQL.
What i am trying to do is to obtain information from the db using 3 conditions.
this is what i've got
$sql_num = mysql_query("SELECT * FROM siteinfo WHERE dive_operator = '1' AND status =
'1'",$db) or die (mysql_error());
the 3 conditions i need is
dive_operator=1
destination=whatever
status=1
how can i add destination=whatever to the mix?
thanks in advance for your assistance.