Russia Posted March 29, 2011 Share Posted March 29, 2011 Hey guys, I am having a bit of trouble, I am using the function time() to insert the time the form was submitted to the database. It inserts the data like this: 1301407145 I have a date column. I am then trying to echo the date the person submitted the form from the database using: <?php echo date('d-M-Y h:i A', $date); ?> the $date gets used with the mysql fetch array and for some reason it outputs it as: 01-Jan-1970 01:00 AM Can someone explain to me why? I am using this to insert into the db. $date = time(); and then the $date goes into the statement. mysql_query("INSERT INTO messages (reciever, sender, subject, message, date) VALUES ('$reciever', '$user', '$subject', '$message','$date')") or die (mysql_error()); Why isnt it working? Quote Link to comment Share on other sites More sharing options...
AbraCadaver Posted March 29, 2011 Share Posted March 29, 2011 time() returns the integer timestamp you show, however the MySQL date is probably YYYY-MM-DD. So when you try and store that integer it is invalid and defaults to 1970-01-01 or it defaults to 0000-00-00 and when you use date() on that it returns 01-Jan-1970 01:00 AM (most likely). Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted March 29, 2011 Share Posted March 29, 2011 Why don't you just use the MySQL function NOW()? <?php mysql_query("INSERT INTO messages (reciever, sender, subject, message, date) VALUES ('$reciever', '$user', '$subject', '$message',NOW())") or die (mysql_error()); ?> Ken Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.