Try this, I am assuming that emailerror is one of the fields in your
database.
$thisstart=$massmail[current]-1;
$users=@mysql_query("select
first_name,last_name,email,".$mysql_prefix."users.username
from ".$mysql_prefix."users $leftjoinfirst $leftjoinsecond
limit $thisstart,$massmail[stop]
where vacation<'$curdate' and emailerror = n");
@mysql_query("drop table tmpcmailcttbl");
while ($user=@mysql_fetch_array($users))
-----Original Message-----
From: JeRRy [mailto:jusa_98@yahoo.com]
Sent: Saturday, October 18, 2003 10:07 PM
To: php-db@lists.php.net
Subject: multiple WHERE's
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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
