Dates with PHP and MySQL

[MatthewHSE]

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

[jeffd]

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.