[thelist] [PHP/MySQL] building a select statement from amutilple select field

[Richard Garbutt]

SELECT * FROM cba_condo WHERE bedrooms >= 3 AND bathrooms >= 2 AND
squarefeet >= 1200 AND (city = 'Biloxi' OR city = 'Diamondhead' OR
city = 'Gulfport' OR city = 'Lakeshore')

Or you could use implode() [1]

if ($city[0] != "") { 
  $sql_cities  = " AND (city = '"; 
  $sql_cities .= implode($city, "' OR city = '");
  $sql_cities .= "')"; 
}

[1] http://uk.php.net/implode