Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/hoopstar/public_html/customers.php on line 2
I get this error when I am trying to submit my registration page.
Can someone tell me what is wrong.
the code for the customers.php is: This is the entire page.
<?php
$sql = ' CREATE TABLE hoopstar_osc1.001 ( RegNo int( 11 ) NOT NULL auto_increment ,''FirstName1varchar( 25 ) NOT NULL default \'\','
'LastName1varchar( 25 ) NOT NULL default \'\',''Age1char( 2 ) NOT NULL default \'\',''Sex1enum( \'Y\', \'N\' ) default NULL ,''DOBdate NOT NULL default \'0000-00-00\',''ShirtSize1set( \'S\', \'M\', \'L\', \'XL\' ) NOT NULL default \'\',''FirstName2varchar( 25 ) NOT NULL default \'\',''LastName2varchar( 25 ) NOT NULL default \'\',''Age2char( 2 ) NOT NULL default \'\',''DOB2date NOT NULL default \'0000-00-00\',''Sex2enum( \'Y\', \'N\' ) NOT NULL default \'Y\',''ShirtSize2set( \'S\', \'M\', \'L\', \'XL\' ) NOT NULL default \'\',''FirstNamevarchar( 25 ) NOT NULL default \'\',''LastNamevarchar( 35 ) NOT NULL default \'\',''Addressvarchar( 50 ) NOT NULL default \'\','
'Cityvarchar( 35 ) NOT NULL default \'\',''Statechar( 2 ) NOT NULL default \'\','
'Zipvarchar( 12 ) NOT NULL default \'\',''DayPhonevarchar( 12 ) NOT NULL default \'\','
'EvePhonevarchar( 12 ) NOT NULL default \'\',''CellPhonevarchar( 12 ) NOT NULL default \'\','
'Othervarchar( 12 ) NOT NULL default \'\',''Emailvarchar( 50 ) NOT NULL default \'\','
'NameCardvarchar( 50 ) NOT NULL default \'\',''CardNovarchar( 35 ) NOT NULL default \'\','
'ExpDatedate NOT NULL default \'0000-00-00\',''CardTypeenum( \'Y\', \'N\' ) NOT NULL default \'Y\','
'Schoolset( \'bethesda\', \'potomac\', \'luxamanor\', \'burtonsville\', \'clarksburg\' ) NOT NULL default \'\','
'Costdecimal( 10, 0 ) NOT NULL default \'0\',''Testchar( 2 ) NOT NULL default \'\','
' PRIMARY KEY (RegNo` ) ) ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1';
?>
<?php
$dbh=mysql_connect ("localhost", "hoopstar_test", "test") or die ('I cannot connect to the database because:' . mysql_error());
mysql_select_db ("hoopstar_HoopStartRegistration");
?>
<?php
// perform query
$query="INSERT INTO table values($RegNo, '$FirstName1', '$LastName1', '$Age1', '$Sex1',
'$DOB', '$ShirtSize1', '$FirstName2', '$LastName2', '$Age2', '$DOB2', '$Sex2', '$ShirtSize2', '$FirstName', '$LastName',
'$Address', '$City', '$State', '$Zip', '$DayPhone', '$EvePhone', '$CellPhone', '$Other', '$Email', '$NameCard', '$CardNo',
'$ExpDate', '$CardType', '$School', $Cost)";
$result = mysql_query($query) or die(mysql_error());
echo "Item Entered";
?> 😕
