SELECT alberghi.id, alberghi.stelle,alberghi.stelle_agg,alberghi.nome,alberghi.zona,alberghi.localita,alberghi.nazione,alberghi.provincia, alberghi.regione
FROM booking_engine.canali_alberghi
INNER JOIN booking_engine.alberghi ON alberghi.id=canali_alberghi.id_albergo
WHERE canali_alberghi.id_canale="30" AND canali_alberghi.interfaccia_attiva="si" AND LOWER(alberghi.zona) like "veneto ORDER BY alberghi.zona, alberghi.nome - 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 '"veneto ORDER BY alberghi.zona, alberghi.nome' at line 5 Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/web/aec-internet/www/booking_engine/blocchi_esterni/alberghi_canale.php on line 67