[php/mysql] search query

[Sandro M.]

forse bastano 2 parentesi ma non ne sono sicuro. cmq prova

$searchQuery = ""; 
    $query = ""; 
    $parole = explode(" ",$_POST['searchValue']); 
    foreach ($parole as $word) { 
    $query .= ($query == "") ? "quotidiano LIKE '%".$word."%' OR titolo LIKE '".$word."'" : " AND quotidiano LIKE '%".$word."%' OR titolo LIKE '".$word."' "; 
    } 
    $searchQuery = mysql_query('SELECT *, DATE_FORMAT(data,"%d/%b/%Y") as data FROM blu_archivio WHERE [B]([/B] '.$query.'[B])[/B]  AND category = "comunicati" order by data desc') or die(mysql_error());