multiple WHERE's

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux