TalkPHP - View Single Post

DizzyD · 06-10-2009, 07:12 PM

Thanks for the quick response. The database is set to automatically set the time/date when the entry is made (CURRENT_TIMESTAMP). So the format is set like so:

2009-06-09 20:54:13

So yes I pull it as a string,

$row['time'] displays "2009-06-09 20:54:13"

So i need to get the current time in that same format I would assume, then find the difference of the 2. If it's 8 or more, perform action.

06-10-2009, 07:12 PM	#3 (permalink)
DizzyD The Wanderer Join Date: Feb 2009 Posts: 11 Thanks: 1	Thanks for the quick response. The database is set to automatically set the time/date when the entry is made (CURRENT_TIMESTAMP). So the format is set like so: 2009-06-09 20:54:13 So yes I pull it as a string, $row['time'] displays "2009-06-09 20:54:13" So i need to get the current time in that same format I would assume, then find the difference of the 2. If it's 8 or more, perform action.