how to insert into `db`

[Dirt_Diver]

I am having some trouble. Can someone tell me why this isn't inserting the information into the database?


<?php
// Connects to the Database
include("dbconnect");

//This code runs if the form has been submitted
if (isset($_POST['submit'])) {

// Adding information into the data base.
$username = $_POST['entry_username'];
$theman = $_POST['TeamCap'];
$team = $_POST['team_request'];
$howmany = $_POST['SeasonCount'];
$box = $_POST['terms'];

mysql_query("INSERT INTO signups (entry_username, TeamCap, team_request, SeasonCount, terms)
VALUES ('$username', '$theman', '$team', '$howmany', '$box')")or die(mysql_error());

?>
<center>
Thank you <strong>
<?php
echo $_POST['entry_username']
?></strong> was added to Team <strong><?php
echo $_POST['team_request']
?></strong></center>

<?php
}
else {
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
**** then the form****
****</html>****
<?
}
?>

[Dirt_Diver]

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
<table width="110%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3%" rowspan="7"><div align="center"></div>
<div align="center"></div></td>
<td width="47%" valign="top">* DPCO Entry Username:<br>
<br>
<input name="entry_username" type="text" id="entry_username">
<br>
<br>
<input name="TeamCap" type="radio" value="Y">
Check to be Team Captain?</td>
<td width="9%" align="left" valign="middle"><div align="left"><img src="../images_site/arrow.gif" width="25" height="18"></div></td>
<td width="41%" align="left" valign="middle" class="fade_out_text">Please enter the username that you will be using in the DPCO. Also if you want to be the team captain check the box. (If more than 1 person checks I'll let you know. </td>
</tr>
<tr>
<td><p>&nbsp;</p></td>
<td align="left" valign="middle"><div align="left"></div></td>
<td align="left" valign="middle">&nbsp;</td>
</tr>
<tr>
<td>* Requested Team : <br>
<br>
<select name="team_request" id="team_request">
<option selected> Please choose a team. </option>
<option value="Australia">Australia</option>
<option value="Canada1">Canada I</option>
<option value="Canada2">Canada II</option>
<option value="Canada3">Canada III</option>
<option value="Germany">Germany</option>
<option value="Iceland">Iceland</option>
<option value="Islanders">Islanders</option>
<option value="Poland">Poland</option>
<option value="UK">UK</option>
<option value="USA1">USA I</option>
<option value="K">Team K</option>
<option value="L">Team L</option>
<option value="M">Team M</option>
<option value="N">Team N</option>
<option value="O">Team O</option>
<option value="P">Team P</option>
</select></td>
<td align="left" valign="middle"><div align="left"><img src="../images_site/arrow.gif" width="25" height="18"></div></td>
<td align="left" valign="middle" class="fade_out_text">Please tell me which team you would like to be on. </td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="left" valign="middle"><div align="left"></div></td>
<td align="left" valign="middle">&nbsp;</td>
</tr>
<tr>
<td><p>How many times have you participated in the DPC Olympics?<br>
<br>
<input name="SeasonCount" type="radio" value="1">
This is my 1st tim.<br>
<input name="SeasonCount" type="radio" value="2">
2nd seasons for me.<br>
<input name="SeasonCount" type="radio" value="3">
This is my 3rd time.<br>
<input name="SeasonCount" type="radio" value="4">
4th time pro here.</p></td>
<td align="left" valign="middle"><div align="left"><img src="../images_site/arrow.gif" width="25" height="18"></div></td>
<td align="left" valign="middle" class="fade_out_text">Please tell me how many times you have participated in the DPC Olympics. </td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="left" valign="middle"><div align="left"></div>
<div align="left"></div></td>
<td align="left" valign="middle">&nbsp;</td>
</tr>
<tr>
<td>*
<input name="terms" type="checkbox" id="terms" value="1">
I have read the rules and I understand how the scores will be calculated. I'm ready to play. <br>
<br>
<input type="submit" name="Submit" value="Submit">
<br></td>
<td align="left" valign="middle"><div align="left"><img src="../images_site/arrow.gif" width="25" height="18"></div></td>
<td align="left" valign="middle" class="fade_out_text">Please make sure that you understand how the scoring system works. </td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td align="left" valign="middle"><div align="left"></div></td>
<td align="left" valign="middle">&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td align="left" valign="middle"><div align="left"></div></td>
<td align="left" valign="middle">&nbsp;</td>
</tr>
</table>
</form>

[Nile]

PHP is case sensitive.


if (isset($_POST['submit'])) {
Change the highlighted to a capital S.

[Dirt_Diver]

Got it thank you so much

[Nile]

Glad to help you anytime Dirt_Driver. And your welcome. :)