RTS Posted August 19, 2006 Share Posted August 19, 2006 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? Quote Link to comment Share on other sites More sharing options...
Woolf Posted August 19, 2006 Share Posted August 19, 2006 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]); Quote Link to comment Share on other sites More sharing options...
RTS Posted August 19, 2006 Author Share Posted August 19, 2006 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". Quote Link to comment Share on other sites More sharing options...
corbin Posted August 19, 2006 Share Posted August 19, 2006 Ummm i think your query is structured wrong... Can you post some code? 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.