--- John Holmes <holmes072000@xxxxxxxxxxx> wrote: > Stuart Felenstein wrote: > > if(isset($stateReloc2)) $aWHERE[] = "Prof.State1 > IN > > ($stateReloc2)"; > > You need to check if $stateReloc2, etc are empty() > instead of set. > If the variable is set, but empty, you're going to > end up with a > query like "Prof.State1 IN ()" which will cause your > error, which > we would have seen if you'd just posted the query... > hmmmm....okay I will try that , though I was only going on another search page I set up with isset() and that one is working. Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
