timestamp and NOW('') in php / mysql

From: Date: Fri, 04 Aug 2000 18:14:39 +0000
Subject: timestamp and NOW('') in php / mysql
Groups: php.general 
Request: Send a blank email to php-general+get-10173@lists.php.net to get a copy of this message
Hello all I have been writing a job tracking system but am having a few problems with getting a sensible validation of the timestamps i have set. i insert a record containing data , one of the fileds is time_stamp with the value NOW('') When i try to compare the mysql NOW('') stamp and mktime() they are very very different for e.g. : <SNIP> $my_new_time_stamp = mktime (); print ("<BR>output new stamp: $my_new_time_stamp"); print ("<BR>output db value : $myrow->time_stamp"); the output: output new stamp: 965411494 output db value : 20000804185021 so am i using the xorrect type of comparison ? probably not. Any ideas / advice gratefully recieved :) thx Neil

« previous php.general (#10173) next »