Parse Error: parse error, unexpected T_VARIABLE

[chriscitrix]

I've been staring at this code for far too long, so I'm hoping someone here can help me out with what I'm missing that would be giving me this error. Thanks in advance!

<?

$id = $_REQUEST['id'];
$date = date(Ymd);
$agent = $_REQUEST['agent'];
$aemail = $_REQUEST['aemail'];
$prod = $_REQUEST['prod'];
$acctemail = $_REQUEST['acctemail'];
$custname = $_REQUEST['custname'];
$custemail = $_REQUEST['custemail'];
$custphone = $_REQUEST['custphone'];
$custreq = $_REQUEST['custreq'];
$resexp = $_REQUEST['resexp'];
$authcc = $_REQUEST['authcc'];
$mgr = $_REQUEST['mgr'];
$completed = $_REQUEST['completed'];
$comdate = $_REQUEST['comdate'];
$resolution = $_REQUEST['resolution'];

$dbserver = "localhost";
$dbuser = "cccustom"; 
$dbpass = "xxxxx";
$db = "cccustom";
$table = "legacy"; 
$link = mysql_connect($dbserver,$dbuser,$dbpass);
if (!$link) {
die("Couldn't Connect"); 
}
mysql_select_db($db) or die("Unable to Open " . mysql_error());
$query = "insert into $table (id, date, agent, aemail, prod, acctemail, custname, custemail, custphone, custreq, resexp, authcc, mgr, completed, comdate, resolution) values( NULL, '$date', '$agent', '$aemail', '$prod', '$acctemail', '$custname', '$custphone', '$custreq', '$expres', '$authcc', '$mgr', '$completed', '$comdate', '$resolution' )";
mysql_query($query,$link) or die("Unable to Open " . mysql_error());;

  $email = $_REQUEST['email'] ;
  $message = $_REQUEST['message'] ;

  mail( "[e-mail]", "Custom Request Form Submission",
    $message, "From: $email" );
  header( "Location: http://custcare/submitted.php" );
?>

[Kudose]

<?
$id = $_REQUEST['id'];
$date = date("Ymd");
$agent = $_REQUEST['agent'];
$aemail = $_REQUEST['aemail'];
$prod = $_REQUEST['prod'];
$acctemail = $_REQUEST['acctemail'];
$custname = $_REQUEST['custname'];
$custemail = $_REQUEST['custemail'];
$custphone = $_REQUEST['custphone'];
$custreq = $_REQUEST['custreq'];
$resexp = $_REQUEST['resexp'];
$authcc = $_REQUEST['authcc'];
$mgr = $_REQUEST['mgr'];
$completed = $_REQUEST['completed'];
$comdate = $_REQUEST['comdate'];
$resolution = $_REQUEST['resolution'];

$dbserver = "localhost";
$dbuser = "cccustom"; 
$dbpass = "xxxxx";
$db = "cccustom";
$table = "legacy"; 
$link = mysql_connect($dbserver,$dbuser,$dbpass);
if (!$link) {
die("Couldn't Connect"); 
}
mysql_select_db($db) or die("Unable to Open " . mysql_error());
$query = "insert into $table (id, date, agent, aemail, prod, acctemail, custname, custemail, custphone, custreq, resexp, authcc, mgr, completed, comdate, resolution) values( NULL, '$date', '$agent', '$aemail', '$prod', '$acctemail', '$custname', '$custphone', '$custreq', '$expres', '$authcc', '$mgr', '$completed', '$comdate', '$resolution' )";
mysql_query($query,$link) or die("Unable to Open " . mysql_error());

  $email = $_REQUEST['email'] ;
  $message = $_REQUEST['message'] ;

  mail( "[e-mail]", "Custom Request Form Submission",
    $message, "From: $email" );
  header( "Location: http://custcare/submitted.php" );
?>

date(Ymd) should be date('Ymd') and you have two semi-colons on a die statement.

[chriscitrix]

Thank you :-)

With that ... now I'm getting the following error:

"Unable to Open Column count doesn't match value count at row 1"

I'm assuming this has to do with the fact that 'id' is set to auto-increment ... ? But what to do to fix it?

[laserlight]

You listed 16 columns, but provided the values to 15 of them. You need to fix that, and aside from that, you might as well, not list the autoincremented column instead of passing null to it.

[chriscitrix]

Thank you ... I knew it was something dumb ... eyes are getting tired ... been at this too long tonight :-P

[chriscitrix]

Kudose wrote:

<?
  mail( "[e-mail]", "Custom Request Form Submission",
    $message, "From: $email" );
  header( "Location: http://custcare/submitted.php" );
?>

date(Ymd) should be date('Ymd') and you have two semi-colons on a die statement.

Is this the correct way to e-mail that same data (changing the variable names of course) after appending it to a dB?

[Kudose]

No.

mail( "[e-mail]", "Custom Request Form Submission",
    $message, "FROM: Name <$email>\r\n" );