Date Comparison

DevanandSatdev

Hi Guys,
I have a small issue and i don`t know how to go about resolving it. I have a drop down with dates in the form of 1 Aug, 15 Aug and so on and I have a datebase with a field date which stores date in the form of 1 Aug, 15 aug. Now i need a script where i can check the current date with the date selected and then permit the user to go to the next page if the date is within a limit. say if the date is more then 1st of Aug then the visitor cannot select 1st of Aug. I hope you guys have understood what i want. I am novice and need to know the script in which i can do so.

rulian

this isnt complicated but there is more to it then just copy/pasting a script into your files.
Basically what you can do is do a date comparison from a mysql table to match dates past your "cut off" date. You have to check your database for valid dates, you can either do this to generate your drop down so that only valid date's show, or let the user select which ever date they want and simply check if it's good after form submission.
either way, it's more involved then just a SQL problem, so links and code would help us out alot

DevanandSatdev

Thanks alot for a reply... let me explain you what i am looking for. i have a database of guys working under me, and i want to pull a report with condition like, i want the name of guys who are 12 months old and next 24 months old as on today and so on i doing this program using mysql and php on a appache server now i don`t know how to go about doing it.