[ App->liste():217 ] SELECT *,CAST(prix_promo AS DECIMAL(19,2)) as pp FROM produits WHERE id_region = ORDER BY nom ASC 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 nom ASC' at line 1