grazie, funziona ma ho ancora un errore...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'%%\' and region like \'%%\' and province like \'%%\' and city like \'%milano%\' at line 1

qui

Codice PHP:
 $q "select count(*) from hotels where 1 ";
            
$r mysql_query($q.$where);
88         $count mysql_result($r,0,"count(*)") or die(mysql_error()) ;
            
$pages ceil($count/$PERPAGINA);
            
$from = ($currentPage-1)*$PERPAGINA