php / mysql date and time arithmetic

[jguida]

I have a support request system built with php and mysql. In the db I have 2 timestamp fields, reqdatetime and closedatetime, which signify when the support request was made and when the request was closed. I want to find out how long each request takes to complete in seconds (or whatever is easiest). I then compare that number to the requested number of days that the customer wanted it done in, to see if we were on time, ahead of time, or late. Yes, I know about time_to_sec, but unless I have overlooked something, that function only uses the time portion of the datetime stamp. Some of our requests take many days, and time_to_sec is only returning the difference between the 2 times (not including the number of days) so the results are wrong.

Thanks in advance.

[Anon]

Goto code library under calander dates I have some code there that you can adjust to fit your needs I bet. Look at "Date/Time Count Down". I have recently learned there is a much shorter way to do what I have done there but dont have it in front of me right now but what is there works. Im totally new really to php and dont know what im doing so would appreciate any feedback. Let me know if that helps.