clint6998

And that is the one thing that drives anyone crazy...missing something so small yet valuable... Thanks you!

Title says it all. Here is the error I get: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','1-11-111-11-11-11111','',now())' at line 1 Upload script looks like this: if($_POST['doSubmit'] == 'Add Distributor') { if (!$link) { die('Could not connect: ' . mysql_error()); } $name_dist=mysql_real_escape_string($_POST['name_dist']); $address_dist=mysql_real_escape_string($_POST['address_dist']); $city_dist=mysql_real_escape_string($_POST['city_dist']); $state_dist=mysql_real_escape_string($_POST['state_dist']); $zip_dist=mysql_real_escape_string($_POST['zip_dist']); $phone_dist=mysql_real_escape_string($_POST['phone_dist']); $ffl_dist=mysql_real_escape_string($_POST['ffl_dist']); $dob_dist=mysql_real_escape_string($_POST['dob_dist']); $sql="INSERT INTO `distributors` (name_dist,address_dist,city_dist,state_dist,zip_dist,phone_dist,ffl_dist,dob_dist,dateAdded_dist) VALUES ('$name_dist','$address_dist','$city_dist','$state_dist','$zip_dist',$phone_dist','$ffl_dist','$dob_dist',now())"; if (!mysql_query($sql,$link)) { die('Error: ' . mysql_error()); } echo "<div class=\"msg\">New Distributor Added....done.</div>"; } Form looks like this: <p><?php if(!empty($msg)) { echo $msg[0]; } ?></p> <table width="100%" border="0" cellpadding="5" cellspacing="2" class="myaccount"> <tr> <td style="text-align:right"><form name="addNew" id="addNew" method="post" action="distributors.php">Name of Distributor or Consignor: </td> <td style="text-align:left"><input name="name_dist" type="text" id="name_dist" size="40" class="required"></td> </tr> <tr> <td style="text-align:right">Street: </td> <td style="text-align:left"><input name="address_dist" type="text" size="40" class="required" id="address_dist"></td> </tr> <tr> <td style="text-align:right">City: </td> <td style="text-align:left"><input name="city_dist" type="text" size="40" class="required" id="city_dist"></td> </tr> <tr> <td style="text-align:right">State: </td> <td style="text-align:left"><input name="state_dist" type="text" size="40" class="required" id="state_dist"></td> </tr> <tr> <td style="text-align:right">Zip: </td> <td style="text-align:left"><input name="zip_dist" type="text" size="40" class="required" id="zip_dist"></td> </tr> <tr> <td style="text-align:right">Phone Number: </td> <td style="text-align:left"><input name="phone_dist" type="text" id="phone_dist" size="40" class="required"></td> </tr> <tr> <td style="text-align:right">FFL: </td> <td style="text-align:left"><input name="ffl_dist" type="text" id="ffl_dist" size="40"></td> </tr> <tr> <td style="text-align:right">DOB if no FFL: </td> <td style="text-align:left"><input name="dob_dist" type="text" id="dob_dist" size="40"></td> </tr> <tr> <td colspan="2" style="text-align:center"><input name="doSubmit" type="submit" id="doSubmit" value="Add Distributor"></form></td> </tr> </table> DB table looks like this: `id_dist` int(11) NOT NULL AUTO_INCREMENT, `name_dist` varchar(255) COLLATE latin1_general_ci NOT NULL, `address_dist` text COLLATE latin1_general_ci NOT NULL, `city_dist` varchar(100) COLLATE latin1_general_ci NOT NULL, `state_dist` varchar(2) COLLATE latin1_general_ci NOT NULL, `zip_dist` int(5) NOT NULL, `phone_dist` varchar(255) COLLATE latin1_general_ci NOT NULL, `ffl_dist` varchar(255) COLLATE latin1_general_ci NOT NULL, `dob_dist` varchar(10) COLLATE latin1_general_ci NOT NULL, `dateAdded_dist` date NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (`id_dist`), UNIQUE KEY `name_dist` (`name_dist`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ; Any ideas on why I am getting that error? I have other forms that use this same setup and they work fine so I am not sure what I am missing or have done wrong. Any help would be appreciated. Thanks, Clint

Hello from the newbie! I have a form that I need to post the data to my MySQL db and it is not working. It says that it uploaded it, but it doesn't upload the data. Strange thing is that when I go to re-enter the information, it says that the serial number is already in the system. Here is the php process: <?php if($_POST['doSubmit'] == 'Add') { $rs_dup = mysql_query("select count(*) as total from firearms where serialNumber='$post[serialNumber]'") or die(mysql_error()); list($dups) = mysql_fetch_row($rs_dup); if($dups > 0) { die("That Serial Number already exists in the system."); } mysql_query("INSERT INTO `firearms` (`manufacturer`,`model`,`serialNumber`,`caliber`,`type`,`receiptDate`) VALUES ('$post[manufacturer]','$post[model]','$post[serialNumber]','$post[caliber]','$post[type]',now()) ") or die(mysql_error()); echo "<div class=\"msg\">New Firearm Added....done.</div>"; } ?> Here is the form: <p><?php if(!empty($msg)) { echo $msg[0]; } ?></p> <table width="100%" border="0" cellpadding="5" cellspacing="2" class="myaccount"> <tr> <td width="50%" style="text-align:right"><form name="addNew" id="addNew" method="post" action="new.php">Name of Manufacturer and/or Importer: </td> <td width="50%" style="text-align:left"><input name="manufacturer" type="text" id="manufacturer"></td> </tr> <tr> <td style="text-align:right">Model of Firearm: </td> <td style="text-align:left"><input name="model" type="text" id="model" class="required"></td> </tr> <tr> <td style="text-align:right">Firearm Serial Number: </td> <td style="text-align:left"><input name="serialNumber" type="text" id="serialNumber" class="required"></td> </tr> <tr> <td style="text-align:right">Caliber or Gauge of Firearm: </td> <td style="text-align:left"><input name="caliber" type="text" id="caliber" class="required"></td> </tr> <tr> <td style="text-align:right">Type of Firearm (pistol, revolver, shotgun, rifle,etc.): </td> <td style="text-align:left"><input name="type" type="text" id="type" class="required"></td> </tr> <tr> <td colspan="2" style="text-align:center"><input name="doSubmit" type="submit" id="doSubmit" value="Add"></form></td> </tr> </table> Here is the db structure: CREATE TABLE IF NOT EXISTS `firearms` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `manufacturer` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '', `model` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '', `serialNumber` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '', `caliber` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '', `type` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '', `receiptDate` date NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (`id`), UNIQUE KEY `serialNumber` (`serialNumber`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ; Attached is an image of what whose up when the form is processed. It is making an entry, but only populates the 'id' and 'date' fields. Any help would be greatly appreciated!!! Thanks, CLint