Jump to content


Photo

Dynamic function to select mysql data based on date


  • Please log in to reply
1 reply to this topic

#1 tdnxxx444

tdnxxx444
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 03 March 2006 - 12:07 AM

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?

#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 03 March 2006 - 12:56 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users