DonaldFaulknor

Thank you thank you very much. That worked. What's been frustrating me for 4 hours was solved in a few minutes on this forum. Trust me, I'll be back. Hopefully to help others out. I hope you have a wonderful day. By the way, the verification questions, require some to search Google lol, like me. I didn't know Rasmus' last name, just like I have to search Google for John, George, Paul, and ..... Someone should tell the site administrator to make them more simple, like, what is 5 plus 2 or something. lol. Thanks for the help!

wow, this was the first website EVER that required a Google search in order to register. Anyways... What reason does now() function not work in MySql 5 and how can I get it to work? Most sources online will say you can set now() as default for a datetime field, but that's incorrect, you can't. Also, I've tried inserting it through php, which also didn't work. mysql_query("INSERT INTO table_name(field1, field2, whens) VALUES('$value1','$value2','now()')"); mind you, in this sql query, field1, and field2 ARE properly inserting, so it's not an issue with connecting to the database or inserting in general. The values are passed from a form. I have tried also passing the now() function through the form, that also didn't work. Would appreciate some help. Thank You.