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