I'm having issues getting my query to return any data. I'm trying to find a way to query between two dates (dynamically entered into the query, one being today, the other being either end of month of one month from now) while still having the query sort the data for me. Previously I had PHP do this work for me, but I'm looking to essentially streamline my code. I had my script print the query prior to the query being run and I pasted it below.
Here is my query, does anyone see any issues.
SELECT * FROM events WHERE date BETWEEN '2010-12-09' AND '2011-01-09' ORDER BY date ASC, starttime ASC, endtime ASC