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 ') AS DIF_PRIX FROM annonces
WHERE type_annonce=''
AND referenc' at line 1 SELECT *,ABS(prix_loyer_prix_de_cession-) AS DIF_PRIX FROM annonces
WHERE type_annonce=''
AND reference_agence_du_bien!='2237'
AND prix_loyer_prix_de_cession>=0
AND prix_loyer_prix_de_cession<=0
ORDER BY DIF_PRIX