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? Link to comment https://forums.phpfreaks.com/topic/116521-solved-change-a-columns-attributes/ 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()) Link to comment https://forums.phpfreaks.com/topic/116521-solved-change-a-columns-attributes/#findComment-599324 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! Link to comment https://forums.phpfreaks.com/topic/116521-solved-change-a-columns-attributes/#findComment-599533 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.