Bahamas Real Estate Agent Finder

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 's Cay' AND renewal > DATE_ADD(CURDATE(), INTERVAL -31 DAY) orde: SELECT fname,lname,id,island,town, category from agents where island='Walker's Cay' AND renewal > DATE_ADD(CURDATE(), INTERVAL -31 DAY) order by lname, fname LIMIT 0,10