Hi there - I know that you can use NOW() in MySQL to add the datetime but I was wondering how I can insert the datetime using PHP into MySQL. I dont want to use timestamp.
I have tried using <? echo date() ?> or using variables such as <? echo $date ?> where I have defined $date in the format YYYY-MM-DD HH:MMS in the hidden field but when the insert occurs the datetime field remains 0000-00-00 00:00:00.
Why are you putting it into a hidden field? Do you need to know the difference between the time the page was loaded and the time the form was submitted? Once you have submitted the form THEN grab the date using ISPServer's PHP code.