orwhere qui ne fonctionne pas
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| case 'dpt':
if (is_array($criteria['dpt'])) {
$strWhere = 'candidatures.departement like "'.$criteria['dpt'][0].'"';
for($i=1;$i<sizeof($criteria['dpt']);$i++) {
$strWhere .= 'OR candidatures.departement like "'.$criteria['dpt'][$i].'" ';
}
$select->where($strWhere);
}else{
$select->where('candidatures.departement like ?',$criteria['dpt']);
}
if (is_array($criteria['dpt'])) {
$strWhere = 'cp like "'.$criteria['dpt'][0].'%"';
for($i=1;$i<sizeof($criteria['dpt']);$i++) {
$strWhere .= 'OR cp like "'.$criteria['dpt'][$i].'%" ';
}
$select->orwhere($strWhere);
}else{
$select->orwhere('cp like ?',$criteria['dpt'].'%');
}
break; |