Jump to content

Archived

This topic is now archived and is closed to further replies.

RTS

How to make a timestamp

Recommended Posts

I dont get how I can make a timestamp so when I submit a form with text, the time goes next to it in the database. can someone tell me how?

Share this post


Link to post
Share on other sites
You can do it directly in the mysql table, I do believe, however, I do not use that... since I use my own time formatting script. What I do, is add a column to the table (such as 'time'), and then for each database insert, I put the current time in for the value (e.g.... [i]time()[/i]);

Share this post


Link to post
Share on other sites
I get this error [code]Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': August 18, 2006, 10:11 pm)' at line 1[/code] what does this mean, and what should I do? I have the type set to "date", and the name as "time".

Share this post


Link to post
Share on other sites
Ummm i think your query is structured wrong... Can you post some code?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.