Re: [Jason] Search problem
Hi,
i try this, but it does not work:
two fields(multi values)
1 - oblast_grad
2 - vid_na_imota
$where = "";
if (is_array(@$_REQUEST['oblast_grad'])) {
foreach ($_REQUEST['oblast_grad'] as $oblast_grad) {
$where .= " oblast_grad LIKE '%\t".mysql_escape($oblast_grad)."\t%' OR";
}
$where = rtrim($where, "OR");
}
if (is_array(@$_REQUEST['vid_na_imota'])) {
foreach ($_REQUEST['vid_na_imota'] as $vid_na_imota) {
$where .= " vid_na_imota LIKE '%\t".mysql_escape($vid_na_imota)."\t%' OR";
}
$where = rtrim($where, "OR");
}
list($imotiRecords, $imotiMetaData) = getRecords(array(
'tableName' => 'imoti',
'orderBy' => mysql_escape(@$_REQUEST['orderBy']),
'perPage' => '2',
'where' => $where,
));
and search form:
<div style="margin-left:20px; margin-right:20px; position:relative;">
<form id="search" name="search" method="GET" action="results.php">
<div style="float:left; width:300px; margin-right:20px;">
<div>Вид на имота</div><div><select id="state" name="vid_na_imota[]" size="5" multiple="true">
<option value="1-стаен" selected="selected">1-стаен</option>
<option value="2-стаен" selected="selected">2-стаен</option>
<option value="3-стаен">3-стаен</option>
<option value="4-стаен">4-стаен</option>
<option value="Многостаен" selected="selected">Многостаен</option>
</select></div></div>
<div style="float:left; width:300px; margin-right:20px;">
<div>Квартал/Район</div>
<div><select id="city" name="oblast_grad[]" multiple="multiple" size="5">
<optgroup label="Трошево, Младост, Възраждане">
<option value="Трошево">Трошево</option>
<option value="Младост">Младост</option>
<option value="Възраждане">Възраждане</option>
</optgroup>
<optgroup label="Владислав Варненчик, Кайсиева градина">
<option value="option4">Владислав Варненчик</option>
<option value="option5">Кайсиева градина</option>
</optgroup>
</select>
</div>
</div>
<div style="float:left; width:300px; margin-right:20px;"><input type="submit" name="submit" value="Search" /></div>
</form></div>
when chooce 1 option from vid_na_imota and 1 option from oblast_grad it does not do the search correct. Maybe my code is wrong :(