Dates with PHP and MySQL
MatthewHSE
Status: Contributor
Joined: 20 Jul 2004
Posts: 122
Location: Central Illinois, typically glued to a computer screen
Reply Quote
I'm working on a PHP script that will integrate with date-sensitve information. Basically, I need to be able to create fields for a "Start date" and an "End date" to each row in a MySQL database. When the script reads a database row, it needs to do different things depending on when the request is made.

Specifically, I need the script to be able to tell if the current date is on or between the "Start date" and the "End date" for the database row it's working with.

For some odd reason, I have a hard time understanding PHP and MySQL date functions. Where should I start to achieve this functionality?

Thanks,

Matthew
Back to top
jeffd
Status: Assistant
Joined: 04 Oct 2003
Posts: 594
Reply Quote
good question, mysql date functions are sort of confusing. I'll post a solution some time in the next few days, unless someone else has one.
Back to top
Display posts from previous:   

All times are GMT - 8 Hours