PHP/MySQL date/time difference

I've faced a little trouble while i'm working with PHP:$now = date('Y-m-d H:i:s', time());

and MySQL: UPDATE users SET user_lastactivity=NOW()

The problem is, that after i have my data in DB, and when i compare both of them, there is 25 sec difference ... why this happens, when both of them are used for same time (now) and 开发者_StackOverflowhow i can fix this.Thank you guys!

now will give you the time when this function is being executed. And in you case the are being executed at different time.

If you want to use same time for both statement you can assign $now = NOW();

And use this $now in both places. In query as well as for comparison.

UPDATE users SET user_lastactivity = $now ;

Why don't you use the php var $now in your request to be sure to have the same referential?

UPDATE users SET user_lastactivity = $now