chordsoflife Posted July 25, 2008 Share Posted July 25, 2008 I'm working on my first real PHP/MySQL project, and keeping things VERY simple. Right now, I've got a form that creates new posts on the homepage of the site. It's got an id, title, content, and a date. I'm on a university server, so I'm somewhat limited in what I can do, so all my commands are unix. My problem: I didn't add "auto" (i think) to the date column, so my date is always 0000-00-00. Can anyone help me with the unix to change this? Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted July 25, 2008 Share Posted July 25, 2008 If u want to set a date you can simply use the Mysql function NOW() instead of a string example Insert into `table` (Name, Date) VALUES('Bob', NOW()) Quote Link to comment Share on other sites More sharing options...
chordsoflife Posted July 25, 2008 Author Share Posted July 25, 2008 Alright, cool, that worked great- committed to memory and appreciated! 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.