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? Link to comment https://forums.phpfreaks.com/topic/18012-how-to-make-a-timestamp/ 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]); Link to comment https://forums.phpfreaks.com/topic/18012-how-to-make-a-timestamp/#findComment-77122 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". Link to comment https://forums.phpfreaks.com/topic/18012-how-to-make-a-timestamp/#findComment-77126 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? Link to comment https://forums.phpfreaks.com/topic/18012-how-to-make-a-timestamp/#findComment-77140 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.