Narrow Error down - Got Parse Error

[vtaylor263]

Dear PHP Group:

I have finally narrowed my error down. I re-arrange my database and re-wrote the script and received a parse error on line 17.

PHP does not like my TimeStamp Field. I need to set 14 (0s) in the StartDateTime field because I will update this field later.

Here's my code.

$EnrolledDate = date("Y-m-d");
$AllottedTime = 3.00;
$AccumulatedTime = 0.00;
$Email = "[e-mail]";
$ItemNo = 154327;
$StartDateTime = 00000000000000; (this is line 17 in my code)

mysql_connect('IP','username','password') or die('Error: Unable to connect to the database server.');
mysql_select_db('conte5') or die('Error: Unable to select proper database.');

srand((double)microtime() * 1000000);
$Password = substr(md5(uniqid(rand())),0,10);

$ExecuteQuery = mysql_query("INSERT INTO Validation VALUES (Null, '$ItemNo', '$Email', '$Password', '$AllottedTime', '$AccumulatedTime', '$EnrolledDate', '$StartDateTime')") or die('Error: Unable to execute insertion query.');
mysql_close();

My question, why does the StartDateTime create parse errors when I run this script? The StartDateTime field data type is
TimeStamp (14) Default '00000000000000' . This should run.

What should I do to make the script run without parse errors.

I need actually script examples not just verbiage.

[BeastRider]

Originally posted by vtaylor263
My question, why does the StartDateTime create parse errors when I run this script? The StartDateTime field data type is
TimeStamp (14) Default '00000000000000' . This should run.

It doesn't create a parse error. You can take that line and put it in another script and it executes fine. Need to see your code to know more.

But, a PS: Your $StartDateTime variable will be loaded as an integer with value 0 (whether or not you put 14 zeros in or not). The largest value possible in php is a signed int which is 2,147,483,648, which if you will notice is 10 digits. Perhaps you want quotes around all your zeros to create a 14 character long string?