Jump to content

Archived

This topic is now archived and is closed to further replies.

tdnxxx444

Dynamic function to select mysql data based on date

Recommended Posts

I want to create a dynamic, generic function that will SELECT data from a mysql table based on various types of dates.
The dates could be in the form of:

1. No date
2. A specific date
3. A date range
4. x many months from the current date
i.e. mysql statement - EXTRACT(YEAR_MONTH FROM date) = EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(), INTERVAL x MONTH))
5. etc -- whatever other variations

Anyone have any suggestions on the best way of accomplishing this?

Share this post


Link to post
Share on other sites
if () {

} elseif () {

} elseif() {

} ....


:)

Aren't those all basically date ranges? Have the user give you a start and an end, and figure out good defaults when they leave one or both empty.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.