multiple WHERE's
| From: | JeRRy | Date: | Sun, 19 Oct 2003 05:07:07 +0000 |
| Subject: | multiple WHERE's | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31121@lists.php.net to get a copy of this message | ||
Hi,
I have this code that I want to have multiple WHERE
statements. Could someone help me please. What I
want added is:
WHERE emailerror = n
So if 'emailerror = y' it wont send an eamil but if
set to 'n' it will.
Code below...
$thisstart=$massmail[current]-1;
$users=@mysql_query("select
first_name,last_name,email,".$mysql_prefix."users.username
from ".$mysql_prefix."users $leftjoinfirst where
vacation<'$curdate' $leftjoinsecond limit
$thisstart,$massmail[stop]");
@mysql_query("drop table tmpcmailcttbl");
while ($user=@mysql_fetch_array($users))
Jerry
http://personals.yahoo.com.au - Yahoo! Personals
New people, new possibilities. FREE for a limited time.