Hidden Input Value Not Saving In DB

[mcfly1204]

I have an HTML form that includes several input fields and one hidden input field.

<form name="frm" action="../submit.php" method=get onsubmit="return validate(frm)">
  <table width="350" border="0" cellspacing="0" cellpadding="0" align="center">
    <input type="hidden" name="Type" value="Restaurants" id="Type"/>
    <tr>
    <tr>
      <td class="text"><table width="81%" border="0" cellspacing="6" cellpadding="0">
        <tr>
          <td valign="top" class="text">&nbsp;</td>
          <td valign="top" class="text"><div align="left">Name</div></td>
          <td colspan="3"><div align="left">
            <input type="text" name="Name" cols="45" id="Name">
          </div></td>
        </tr>
        <tr>
          <td valign="top" class="text">&nbsp;</td>
          <td valign="top" class="text"><div align="left">Company</div></td>
          <td colspan="3"><div align="left">
            <input type="text" name="Company" cols="45" id="Company">
          </div></td>
        </tr>
        <tr>
          <td valign="top" class="text">&nbsp;</td>
          <td valign="top" class="text"><div align="left">Address 1</div></td>
          <td colspan="3"><div align="left">
            <input type="text" name="Address1" cols="45" id="Address1">
          </div></td>
        </tr>
        <tr>
          <td valign="top" class="text">&nbsp;</td>
          <td valign="top" class="text"><div align="left">Address 2</div></td>
          <td colspan="3"><div align="left">
            <input type="text" name="Address2" cols="45" id="Address2">
          </div></td>
        </tr>
        <tr>
          <td valign="top" class="text">&nbsp;</td>
          <td valign="top" class="text"><div align="left">City, State, Zip</div></td>
          <td colspan="3"><div align="left">
            <input type="text" name="CityStateZip" cols="45" id="CityStateZip">
          </div></td>
        </tr>
        <tr>
          <td valign="top" class="text">&nbsp;</td>
          <td valign="top" class="text"><div align="left">Phone</div></td>
          <td colspan="3"><div align="left">
            <input type="text" name="Phone" cols="45">
          </div></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td class="text"><div align="left">Email</div></td>
          <td colspan="3"><div align="left">
            <input type="text" name="Email" id="Email"></td>
        </tr>
        <tr>
          <td valign="top" class="text">&nbsp;</td>
          <td valign="top" class="text"><div align="left">Quantity<br>
            Requested/<br>
            Other<br>
            Comments</div></td>
          <td colspan="3"><div align="left">
            <textarea name="Comments" cols="15" rows="5"></textarea></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td><input type="submit" name="Submit" value="Submit">
            <input type="reset" name="Clear" value="Clear" id="Clear"></td>
        </tr>
      </table></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
    </tr>
  </table>
</form>

When I go to insert the input values from within submit.php, all of the input fields save correctly except for the hidden input field. From submit.php:

if(isset($_POST['action']) && $_POST['action'] == 'submitform')
{
    //recieve the variables
 
    $Name = $_POST['Name']; //referrername field posted to referrername column in the db
    $Company = $_POST['Company'];
    $Address1 = $_POST['Address1'];
    $Address2 = $_POST['Address2'];
    $CityStateZip = $_POST['CityStateZip'];
    $Phone = $_POST['Phone'];
    $Email = $_POST['Email'];
    $Comments = $_POST['Comments'];
    $type = $_POST['Type'];
}
 
$phone = remove_non_numeric($phone);
//save the data on the DB
 
mysql_select_db($database, $connection);
 
//insert query would need to be updated to match column names in the db, the number of values would need to correspond to the number of fields
$insert_query = sprintf("INSERT INTO storypac (Name, Company, Address1, Address2, CityStateZip, Phone, Email, Comments, type) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
                        sanitize($Name, "text"),
                        sanitize($Company, "text"),
                        sanitize($Address1, "text"),
                        sanitize($Address2, "text"),
                        sanitize($CityStateZip, "text"),
                        sanitize($Phone, "text"),
                        sanitize($Email, "text"),
                        sanitize($Comments, "text"),
                        sanitize($type, "text"));
 
$result = mysql_query($insert_query, $connection) or die(mysql_error());

I cannot seem to figure out why the value of the hidden field 'Type' is not saved in the database. As for the data types of the columns in the DB, all are varchar(32-64). Any help would be appreciated.

[johny10151981]

Your database field type is char not integer