SELECT * FROM carListings WHERE (regDate between and ) AND sold = 0 AND active = 1 ORDER BY regDate 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 'and ) AND sold = 0 AND active = 1 ORDER BY regDate ASC' at line 1