The problem I'm experiencing is the post is working fine and I echo all of them. There is no error but when I check if inserted to the database, none of the have appeared. Here is the code I have written:
<?php
/* this area is the saving code for the item and description of the pr form */
include("db.php");
$userlogs = mysql_query("SELECT * FROM pr_head ORDER BY rfq_raw_no DESC");
if ($outing = mysql_fetch_array($userlogs)) {
$rfq_raw_no_out = $outing['rfq_raw_no'] + 1;
}
$RFQ_date_out = $_POST['RFQ_date_in'];
$Vendor_Code_out = $_POST['Vendor_Code_in'];
$Vendor_Name_out = $_POST['Vendor_Name_in'];
$Vendor_Adress_out = $_POST['Vendor_Adress_in'];
$Email_Adress_out = $_POST['Email_Adress_in'];
$Tel_No_out = $_POST['Tel_No_in'];
$ATTENTION_out = $_POST['ATTENTION_in'];
$RFQ_NO_out = $_POST['RFQ_NO_in'];
$DEADLINE_out = $_POST['DEADLINE_in'];
$Prepared_By_out = $_POST['Prepared_By_in'];
$Position_out = $_POST['Position_in'];
mysql_query("INSERT INTO `pr_head`(`RFQ_date`, `Vendor_Code`, `Vendor_Name`, `Vendor_Adress`, `Email_Adress`, `Tel_No`, `ATTENTION`, `RFQ_NO`, `DEADLINE`, `rfq_raw_no`, `Prepared_By`, `Position`)
VALUES ([$RFQ_date_out],[$Vendor_Code_out],[$Vendor_Name_out],[$Vendor_Adress_out],[$Email_Adress_out],[$Tel_No_out],[$ATTENTION_out],[$RFQ_NO_out],[$DEADLINE_out],[$rfq_raw_no_out],[$Prepared_By_out],[$Position_out])");
?>
