PDA

View Full Version : Strtotime vs mktime updating an existing date in database ?


mustang_sally_85344510
07-10-2010, 01:17 PM
I am trying to update an existing date in a database table.
the date format is YYYY-MM-DD . (I am NOT using timestamp in this field)

I need to echo this onto a page and add an additional month.
And on another page, I need to add an additional year.

Everything I've tried is not returning the proper results.

Here is my strtotime (which didn't work) :(

<?php strtotime($row_rsFinal['enddate'].'+1 month'); ?>

I initially used mktime to enter the dates in the database...

But I am having great difficulty taking the existing date and adding to it...

Any help would be GREATLY appreciated. :)

UPDATE I FIGURED IT OUT...THANKS :)

Jason Byrnes
07-12-2010, 08:27 AM
Ok, glad to hear you have resolved this issue.