I think I'm almost there :) Only right now I'm getting an error message: "Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3"
<?php $where = array(); $Ind = ""; $Ind = $_POST['Ind']; if (count($Ind) > 1) { $IndStr = implode("','", $Ind); $where[] = "VendorJobs.Industry IN($IndStr)"; }else{ $where[] = "VendorJobs.Industry = {$Ind[0]}"; } ?> <?php $sql = 'SELECT PostStart, JobTitle, Industry, LocationState, VendorID FROM VendorJobs WHERE ' . implode( ' AND ', $where ); $result = mysql_query($sql) or die ("Query failed: " .mysql_error()); while($row = mysql_fetch_assoc($result)) I can't find the problem. Anyone see anything ? Thank you. Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php