Parse error: parse error, unexpected T_STRING in /home/reedsbu/public_html/insert_player.php on line 51
The code is as follows:
<html>
<head>
<title>PLAYER REGISTERED</title>
</head>
<body
background="http://www.reedsburgpolars.com/images/grayice.gif" link="3300CC" alink="000000" vlink="FF0000">
<?php
$host="localhost";
$usrnm="reedsbu_register";
$passwrd="wi53944";
$database="reedsbu_youthhockey";
$tablename="players";
$firstname = $POST["firstname"];
$lastname = $POST["lastname"];
$address=$POST["address"];
$city=$POST["city"];
$state=$POST["state"];
$zip=$POST["zip"];
$dob=$POST["dob"];
$sex=$POST["sex"];
$siblings=$POST["siblings"];
$homephone=$POST["homephone"];
$workphone=$POST["workphone"];
$cellphone=$POST["cellphone"];
$email=$_POST["email"];
$con= mysql_connect($host,$usrnm,$passwrd)
or die("Connection failed!!! <br>");
$varselect=mysql_select_db($database)
or die("Database selection failed!!!");
$query="INSERT INTO players VALUES('".$lastname."',
'".$firstname."',
'".$address."',
'".$city."',
'".$state."',
'".$zip."',
'".$dob."',
'".$sex."',
'".$siblings."',
'".$homephone."',
'".$workphone."',
'".$cellphone."',
'".$email."')";
$varquery=mysql_query($query);
if (!$varquery)
{
die(("Query execution failed!!!<br>" mysql_error(). );
}
else
{
echo "<table border=\"0\" align=\"center\" cellspacing=\"1\"
cellpadding=\"5\" width=\"300\">";
echo " <tr> ";
echo " <td colspan=\"2\"> ";
echo " <center><b>".mysql_affected_rows()."
record entered into the table</b></center>";
echo " </td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">lastname</div>";
echo " </td>";
echo " <td width=\"200\">".$lastname."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">firstname</div>";
echo " </td>";
echo " <td width=\"200\">".$firstname."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">address</div>";
echo " </td>";
echo " <td width=\"200\">".$address."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">city</div>";
echo " </td>";
echo " <td width=\"200\">".$city."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">State</div>";
echo " </td>";
echo " <td width=\"200\">".$state."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">zip</div>";
echo " </td>";
echo " <td width=\"200\">".$zip."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">dob</div>";
echo " </td>";
echo " <td width=\"200\">".$dob."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">sex</div>";
echo " </td>";
echo " <td width=\"200\">".$sex."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">siblings</div>";
echo " </td>";
echo " <td width=\"200\">".$siblings."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">homephone</div>";
echo " </td>";
echo " <td width=\"200\">".$homephone."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">workphone</div>";
echo " </td>";
echo " <td width=\"200\">".$workphone."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">cellphone</div>";
echo " </td>";
echo " <td width=\"200\">".$cellphone."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"100\"> ";
echo " <div align=\"right\">email</div>";
echo " </td>";
echo " <td width=\"200\">".$email."</td>";
echo " </tr>";
echo "</table>";
}
?>
</body>
</html>
