[RESOLVED] Putting date into tabl

[gr-games]

I'm working on a guestbook, and I want to display the time and date somthing was posted. How do I do this?

[cgraz]

Setup a timestamp field in your database (lets call it posted_on for this example):

Then use NOW()

$query = mysql_query("INSERT INTO table (name, body, posted_on) VALUES('bob', 'hello', NOW())");

NOW() will stamp the timestamp field for you upon INSERTing.

Then use DATE_FORMAT when extracting the timestamp out of the database to manipulate the timestamp to display how you want it. Check the link I sent you for more on DATE_FORMAT, or do a search on these forums. It's a really handy tool.

[devinemke]

i'm assuming you are using mySQL

actually if you just want to store the date/time that the record was inserted then i would suggest using the regular DATETIME column type and not the TIMESTAMP type. TIMESTAMP filelds are automatically updated with the current time on each subsequent update, which may not be what you want.

read up on Date and Time Types