'', nome".$lan.", nome) AS nome FROM glbt.lingua WHERE nome".$lan." LIKE '".$_POST['value']."%' OR nome LIKE '".$_POST['value']."%'"; $r = mysql_query($q) or die (mysql_error()); while($rw = mysql_fetch_array($r)){ $results[] = $rw['nome']; } echo json_encode($results); break; case "getNations": $results = Array(); $q = "SELECT id_nazionalita, if(nome".$lan."<>'', nome".$lan.", nome) AS nome FROM glbt.nazionalita WHERE nome".$lan." LIKE '".$_POST['value']."%' OR nome LIKE '".$_POST['value']."%'"; $r = mysql_query($q) or die (mysql_error()); while($rw = mysql_fetch_array($r)){ $results[] = $rw['nome']; } if(stripos("united ", $_POST['value']) === 0){ $results[] = "UK"; $results[] = "USA"; } echo json_encode($results); break; } ?>