how to insert into `db`

**Dirt_Diver** · 01-18-2009, 04:43 AM

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

PHP Code:


<?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** · 01-18-2009, 06:15 AM

HTML Code:

    <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>