Why would my php timestamp and mysql timestamp not match? Mysql's timestamp is set to 'on update' = 'current_time' which is converted with string_to_time() in php to a timestamp. PHP is using the time(); command to get the current timestamp. The values don't match? There off by about 60000 digits? Why is this?
Is MySQL and PHP on the same server? If so... it might be a timezone thing... check the timezone on the server is set properly. Also, which time is actually right? http://www.php.net/manual/en/function.date-timezone-set.php
I did set the timezone in my php.ini file and ran a query in mysql to set the timezone of the server. It still didn't work so I found a work around. I just populated the timestamp field manually through php instead of using mysql's update timestamp function. Therefore the timestamps are in the same timezone, php's.