Timestamp?

[lukeurtnowski]

I have a guestbook which uses a mysql database. I'm trying to figure out how to create anotherfield in my guestbook table to hold the date and time that person filled out my guestbook and actualy display it on the page so I can monitor my when my guestbook was filled out?
Thanks.

[bretticus]

add a field of type TIMESTAMP to your table. When a new guestbook record is inserted, it will automatically get stamped without you having to add any more code to the SQL insert. PLEASE NOTE that subsequent UPDATES to these records will also put the current date in that field (unless you explicitly set it to itself: 'UPDATE table SET [...], createdon = createdon...')

Now, simply query it using the mysql function UNIX_TIMESTAMP(). An example:

'SELECT *, UNIX_TIMESTAMP(createdon) FROM table...' you can now use that value to apply php date() to.