I've talked to my webhost and they suggested setting the timezone for each session. I've tried with the following code:
Code: Select all
mysql_query("SET time_zone = America/Chicago");
$query="INSERT INTO tblRegistrations (firstName,lastName)
$result=mysql_query($query,$mydatabase) or die(mysql_error());
The table has (among others) three columns: timeStamp, firstName, lastName. The timeStamp column is set to have a default value of CURRENT_TIMESTAMP.
Can anyone offer me any suggestions on what to do to solve this problem?