i have two php Forms to insert data into a Mysql 4.0.20d Database, one
is just a simple form to test if it works the other is the Actual
application,
here is the test form and works Perfectly
>>
<?
$name=$_POST['Name'];
$value1=$_POST['value1'];
$value2=$_POST['value2'];
$sum=$_POST['sumfield'];
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("testbase") or die(mysql_error());
mysql_query("INSERT INTO `formadder` VALUES ('$name','$value1',
'$value2','$sum')");
Print "Your information has been successfully added to the database.";
?>
NOW , / here is the Form data submitter that doesn't Work Ive
checked and checked and check this damn Code with my form and nothing is
outta place, ("i dont think")
BUT will NOT Insert anything to the database even though i get no
errors at all and it says "Your information has been successfully added
to the database."; all the feilds are blank
<?
$ordernumber = $_POST['ordernumber'];
$companyname = $_POST['companyname'];
$billingaddress = $_POST['billingaddress'];
$City = $_POST['City'];
$State2 = $_POST['State'];
$Zip = $_POST['Zip'];
$PhoneNumber= $_POST['PhoneNumber'];
$FaxNumber = $_POST['FaxNumber'];
$WebPage= $_POST['WebPage'];
$EmailAddress = $_POST['EmailAddress'];
$Notes = $_POST['Notes'];
$Customer= $_POST['Customer'];
$Startdate = $_POST['Startdate'];
$Completedate = $_POST['Completedate'];
$Biddate= $_POST['Biddate'];
$Bidamount = $_POST['Bidamount'];
$ElecProjCost = $_POST['ElecProjCost'];
$ElecProjBill = $_POST['ElecProjBill'];
$ElecRem = $_POST['ElecRem'];
$CtrlProjCost = $_POST['CtrlProjCost'];
$CtrlProjBill = $_POST['CtrlProjBill'];
$CtrlProjrem = $_POST['CtrlProjrem'];
$OthrProjCost = $_POST['OthrProjCost'];
$OthrProjBill = $_POST['OthrProjBill'];
$OthrProjrem = $_POST['OthrProjrem'];
$BondAm= $_POST['BondAm'];
$BondBill= $_POST['BondBill'];
$BondRem= $_POST['BondRem'];
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("workorder") or die(mysql_error());
mysql_query("INSERT INTO `orders` VALUES (`$ordernumber` ,
`$companyname` , `$billingaddress` , `$City` , `$State2` , `$Zip` ,
`$PhoneNumber` , `$FaxNumber` , `$WebPage` , `$EmailAddress` , `$Notes`
, `$Customer` , `$Startdate` , `$Completedate` , `$Biddate` ,
`$Bidamount` , `$ElecProjCost` , `$ElecProjBill` , `$ElecRem` ,
`$CtrlProjCost` , `$CtrlProjBill` , `$CtrlProjrem` , `$OthrProjCost` ,
`$OthrProjBill` , `$OthrProjrem`, `$BondAm` , `$BondBill` , `$BondRem` )");
Print "Your information has been successfully added to the database.";
?>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
