Sort data with specific time
Posted: Tue Sep 21, 2010 8:03 am
Hi masters..
I am confuse at the moment with time calculation... For example I have table 'order' with field : name and date...
In my search option (menu list), there will be like "3 months ago, 1 year ago, 3 years ago, etc".. whats the syntax in php to calculate the time ? so when i choose 3 months ago, and click search button, it will select data from table where are submitted 3 months ago from the current time... Anyone can explain ? Thanks alot...
I am confuse at the moment with time calculation... For example I have table 'order' with field : name and date...
In my search option (menu list), there will be like "3 months ago, 1 year ago, 3 years ago, etc".. whats the syntax in php to calculate the time ? so when i choose 3 months ago, and click search button, it will select data from table where are submitted 3 months ago from the current time... Anyone can explain ? Thanks alot...