hi there.
can someone tell me what i'm doing wrong? I'm using mktime() to save current
date / time stamp into my database as an INT.
then when i'm displaying the data, i use the date() function to format it.
here's how i create my time stamp variable in php:
$curr_time_stamp = mktime();
here's my logic to display my data:
foreach($result as $row)
{
print "<tr><td>".$row['id']."</td>";
print "<td>".$row['field1']."</td>";
print "<td>".$row['field2']."</td>";
print "<td>".date('Y-m-d h:m:s',$row['updated'])."</td></tr>";
}
on my web page, the time always appears as:
2012-01-23 02:01:03
where the minutes never change. it's always 2:01. but the seconds
increment/change.
any ideas on what i'm doing wrong?
--
View this message in context:
http://old.nabble.com/mktime%28%29-always-returns-same-time-minute-value.-tp33190523p33190523.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
