have an HTML input page and when I submit it, my SQL DB does not update, but I am not receiving any errors, any suggestions? Here is my code:
<?php
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die("Unable to connect to database");
$lastname = $_POST['lastname'];
$firstname = $_POST['firstname'];
$middlename = $_POST['middlename'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];
$dlstate = $_POST['dlstate'];
$dlnumber = $_POST['dlnumber'];
$ssn = $_POST['ssn'];
$dob = $_POST['dob'];
$sex = $_POST['sex'];
$race = $_POST['race'];
$hair = $_POST['hair'];
$eye = $_POST['eye'];
$alias = $_POST['alias'];
$employer = $_POST['employer'];
$homephone = $_POST['homephone'];
$workphone = $_POST['workphone'];
$chargetype = $_POST['chargetype'];
$issuedate = $_POST['issuedate'];
$casenumber = $_POST['casenumber'];
$docketnumber = $_POST['docketnumber'];
$acacode = $_POST['acacode'];
$offensedate = $_POST['offensedate'];
$description = $_POST['description'];
$class = $_POST['class'];
$degree = $_POST['degree'];
$bondtype = $_POST['bodntype'];
$bondamount = $_POST['bondamount'];
$warrantfee = $_POST['warrantfee'];
$agency = $_POST['agency'];
$warranttype = $_POST['warranttype'];
$query = "INSERT INTO warrants
(`lastname`,`firstname`,`middlename`,`address`,`city`,`state`,`zip`,`dlstate`,`dlnumber`,`ssn`,`d
ob`,`sex`,`race`,`hair`,`eye`,`alias`,`employer`,`homephone`,`workphone`,`chargetype`,`issuedate`
,`casenumber`,`docketnumber`,`acacode`,`offensedate`,`description`,`class`,`degree`,`bondtype`,`b
ondamount`,`warrantfee`,`agency`,`warranttype`) VALUES
('$lastname','$firstname,'$middlename','$address','$city','$state','$zip','$dlstate','$dlnumber',
'$ssn','dob','$sex','$race','$hair','$eye','$alias','$employer','$homephone','$workphone','charge
type','$issuedate','$casenumber','$docketnumber','$acacode','$offensedate','$description','$class
','$degree','$bondtype','$bondamount','$warrantfee','$agency','$warranttype')";
if(false === $rs = mysql_query($query))
{
debug($query);
}
else
{
?>Warrant Database Updated<?
}
function debug($query)
{
if($_REQUEST['debug']) print $query;
}
?>
