Hello Shannon, mmhh.. i think this is simple as: Select * from mytable where nextcontact>='$today' and nextcontact<='$week' and (custid=3 or custid=5) and (languaje='de' or languaje='en').... I'm not sure if it helps, but you can ask again or provide an example... ;) SD> Second I need the same scenario, however I want to search from a variety of SD> different fields, show those that are between the dates and are equal to one SD> other criteria. SD> Any help on these two? SD> Cheers, SD> Shannon -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
