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