Select bid, TOWN_LONG, LIST_PRICE, LIST_NO, ACRES, TOT_BATHS, NO_BEDROOMS,PROP_TYPE from properties where  order by LIST_PRICE DESCYou 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 LIST_PRICE DESC' at line 1