Complex Search

[stuffradio]

I'm trying to do a php search script that searches a mysql table with 4 or 5 different checkbox items and about 12 other fields.

 

I'm not sure how the best way would be to do this... I'm trying to use foreach, but how would I do this with the 5 different fields needing to have a checkbox, and they each have at least 2 values.

 

Example:

<input type='checkbox' name='Area[]' value='A'>

<input type='checkbox' name='Area[]' value='B'>

<input type='checkbox' name='Area[]' value='C'>

 

<input type='checkbox' name='City[]' value='A'>

<input type='checkbox' name='City[]' value='B'>

<input type='checkbox' name='City[]' value='C'>

 

etc.

etc.

[Barand]

try something like

<?php
$where = array();
$whereclause = '';

if (isset($_POST['Area']))
{
    $areas = join("','", $_POST['Area']);
    $where[] = "(Area IN ('$areas'))";
}

if (isset($_POST['City']))
{
    $cities = join("','", $_POST['City']);
    $where[] = "(City IN ('$cities'))";
}

if (count($where)) $whereclause = 'WHERE' . join (' AND ', $where);

$sql = "SELECT * FROM mytable $whereclause";
?>