DaniWeb IT Discussion Community - php wont submit data into the database

[php]<?
$DBhost = "localhost";//location of mySQL on server/site
$DBuser = "michael";//User name for logging onto mySQL
$DBpass = "";//Password for logging onto mySQL
$DBName = "user_login_info";//Name of the databse for logging into
$table = "login_info";//Name of the Table to be used steps to create are included
$name = "$_POST[name]";//Name that the person gave on the form
$email = "$_POST[email]";//Email that person gave on the form
$con_email = "$_POST[confirm_email]";//confirm their email is correct
$sex = "$_POST[sex]";//sex of the person
$month = "$_POST[month]";//month person was born
$day = "$_POST[day]";//day person was born
$year = "$_POST[year]";//year person was born

if ($email != $con_email)
{
echo "sorry the emails you provided do not match! ";
echo "Please use the back button to correct this error and resubmit ";
}
else
{
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database"); //connecting to the database using the variable set
@mysql_select_db("$DBName") or die("Unable to select database $DBName"); //at connection to the databse select DBNAME (phpforms) or tell that it couldnt connect
$sqlquery = "INSERT INTO $table VALUES('$id','$name','$email','$email','$con_email','$sex','$month','$day','$year')"; //Telling the mySQL to insert the values from the form into the databse coresponding with the form

$results = mysql_query($sqlquery); //Query the results

mysql_close();

echo "
<html>
<head>
<title> Registerd Data </title>
</head>
<body>
<center>
<table border='0' width='500'>
<tr>";

echo " <td>

<center>
You Just Entered This Information Into the Database
</center>";
//display the information that user submitted in the previous form
echo " <blockquote>
<center>

Name : $name


E-Mail : $email


Sex : $sex


Birthdate: $month / $day / $year

</center>
</blockquote>
</td>
</tr>
</table>
</center>
</body>
</html>";
}
?>[/php]

for some reason i cant get this to submit any data into to my database, ive been trying to create a sort of registration form, so i modified the tutorial that i had been working on, but now it wont send the data to my database, but it will display the information that i have entered at the bottom of the screen (the info is displayed in the 'echo' areas.

heres the code for the form if you need to see that too

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Handling forms with PHP</title>

</head>

<body>

<center> 

<form method="post" action="confirm_reg.php"> 

 <table border="1"> 

  <tr>

   <td colspan="2">

         Please Register to continue!

   </td>

  </tr> 

  <tr>

   <td>

   </td>

  </tr> 

  <tr>

   <td align="left">

        <p><b>  Your Name:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="name" id="name"></p>

        <p><b> E-Mail Address:</b>&nbsp;&nbsp;&nbsp;<input type="text" name="email" id="email"></p>

        <p><b> E-Mail Again:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="confirm_email" id="confirm_email"></p>

        <p><b> Sex:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

          <select name="sex" id="sex">

           <option value="unknown">

                Unknown

           </option> 

           <option value="male">

                Male

           </option> 

           <option value="female">

                Female

           </option> 

          </select></p>

        <p><b> Birthdate:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

        <input type="text" size="2" maxlength="2" name="month" id="month">/

        <input type="text" size="2" maxlength="2" name="day" id="day">/

        <input type="text" size="4" maxlength="4" name="year" id="year"></p>

   </td> 

  </tr>

  <tr>

   <td colspan="2">

        <input type="submit" value="Tell us!">

   </td>

  </tr>

 </table>

</form>

</center>

</body>

</html>