The list boxes are fed by tables that have state and state ID, same for industry. So all the joins are made in the main sql statement and working correctly. --- Doug Thompson <dthompson@xxxxxxxxxxxxx> wrote: > You need LocationState to be, in your example, > Alabama OR California. Also, I would write that SQL > phrase "LocationState = 'Alabama' OR > LocationState='California' ". > > Doug > > Doug > > -- > 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
