SELECT * FROM annonces WHERE DateEvent>=NOW() AND IdShop= ORDER BY DateEvent ASC LIMIT 0, 10 : 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 'ORDER BY DateEvent ASC LIMIT 0, 10' at line 1 RETOUR