searching through arrays in db

rakennedy75

ok, I have some options in an array such as...
options("pool", "washer", "dryer", etc....);
I have a list of checkboxes being populated by this array.

I want to take each of these options and check them to options specific to a search in my database.

So I take options and check to see if they have matching options in the condo database. So if I do a search by room, each element of the array would be checked to the the rooms option. The end result would be that the checkboxes would get checked if they matched.

How would I go about haveing every element in the options array get checked against every element in the pulled data from mysql (using the mysql_fetch_array);

I hope I explained this clearly. Any help would be appreciated.

Thanks

Shrike

Assume that $foo is an array of utilities which a room has (e.g. pool or washer or dryer):

$matched_options = array();
$options("pool", "washer", "dryer");
while($foo = mysql_fetch_array($resultset)){
  foreach($foo as $bar){
    if(in_array($bar, $options){
      $matched_options[] = $bar;
    }
  }
}

$matched_options then contains the matched utilities.

Alternatively you could put the required options directly in the SQL query (if this is feasible, depends on your database design).

$options("pool", "washer", "dryer");
$sql = "SELECT room FROM rooms WHERE ".implode(" = 1 AND ", $options)." = 1";
// $sql = "SELECT room FROM rooms WHERE pool = 1 AND washer = 1 AND dryer = 1";
$result = mysql_query($sql);