I am sending data to my MySQL database. This script was working fine, until I included the 'TIME: auto NOW(TIME' )"; code. So I'm pretty sure I made an error with inserting the time, or it's not formatted correctly. Can anyone locate the problem I've made?
$con = mysql_connect("localhost","myusername","mypassword");
die('Could not connect: ' . mysql_error());
$sql="INSERT INTO Comments (FirstName, Comments, TIME, )
('$_POST[firstname]','$_POST[comments]','TIME: Auto NOW(TIME)' )";
die('Error: ' . mysql_error());
header( 'Location: http://www.mywebsite.com' ) ;