I have MySQL db using the DateTime field type. I have a PHP event calendar that returns all events from today onward (limited to 5 at a time). I want to use a pull down that will allow users to jump to any month in the future and get the events for that month. I can't seem to find a way to write a WHERE clause that will allow me to return only those records that match the month I'm looking for. So I'm wondering what your suggestions would be to handle this.
