John! Your the man! It works! if (!empty(var)) Excellent. I think this is a good lesson in isset. I assumed they were the same. I guess reading the manual more would help. Thank you. Stuart > --- John Holmes <holmes072000@xxxxxxxxxxx> wrote: > > > 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... > > > > I should probably ask - > is this the way to use if(!empty(var)) ? > > Stuart > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
