Selecting Date Range

[Hayezb]

Whats up guys?

 

I'm working on a project and need some help with pulling date ranges from a MySql DB. Our customers need to run a PO Report (Purchase Order), each PO has a date tied to it that they go by. The problem is that this is a weekly report, so the drop down of dates is huge!

 

I want to have 3 drop downs, and they populate based on what they choose. I want them to choose a Year first, then a Month, then it populates the Day drop down with data from that column from that month. Here is an example of what I have in the DB:

 

PODATE

2010-02-05

2010-01-29

2010-01-22

2010-01-15

 

If they chose 2010 as the year, then January as the month, then the 29th, 22nd and 15th would show up in the Day drop down.

 

Thanks guys!

[taquitosensei]

You'll need javascript to do that. If you're already using javascript you might as well use the jquery datepicker it would look a lot cleaner.  You click on the text field and It pops up a calendar, when you click on the date it fills in the text field.