Cod: Selectaţi tot
$search =$_GET['search'];
$search2 = $_GET['search2'];
$search3 = $_GET['search3'];
if($search){
$q1 = " AND lower(server_hostname) LIKE lower('%{$search}%') OR lower(server_map) LIKE lower('%{$search}%') OR lower(server_dns) LIKE lower('%{$search}%') OR server_ip LIKE '%{$search}%' OR game = '{$search}' OR country = '{$search}'";
}
if($search2){
$q2 = " OR lower(server_hostname) LIKE lower('%{$search2}%') OR lower(server_map) LIKE lower('%{$search2}%') OR lower(server_dns) LIKE lower('%{$search2}%') OR server_ip LIKE '%{$search2}%' OR game = '{$search2}' OR country = '{$search2}'";
}
if($search3){
$q3 = " OR lower(server_hostname) LIKE lower('%{$search3}%') OR lower(server_map) LIKE lower('%{$search3}%') OR lower(server_dns) LIKE lower('%{$search3}%') OR server_ip LIKE '%{$search3}%' OR game = '{$search3}' OR country = '{$search3}'";
}
$all = mysql_query("SELECT * FROM tabel WHERE id != ''{$q1}{$q2}{$q3}");
Primul search din link citeste adică funcţionează dar următorul search2 nu merge, cum aş putea face pentru că vreau să caut în baza de date după mai mulţi parametrii.