[RESOLVED] Dates

[ProcalX]

I have coded a booking system for events, each event has a date (dd/mm/yyyy) and this date is stored in this format in the database in three seperate fields as: Day, Month and Year.

The user who booked the event can cancel the booking but I would like it so that the booking can only be cancelled up until 2 days (48 hours) before the event.

I don't know where to start with it as I am not familiar with php time and date function, any help or guidance would be much appreciated!

Thanks

[bradgrafelman]

Assuming your DBMS is MySQL, you should utilize the server's DATE column type; that way, you can use some simple date functions in your SQL queries.