<?php
$objConnect = mysql_connect("localhost","root","") or die ("Error Connect to database");
$objDB = mysql_select_db("db_iservice");
$strSQL = "INSERT INTO requests";
$strSQL .="(fix_price_a,fix_price_b,fix_price_c,fix_price_d,total_service,total_price,totals)";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["fix_price_a"]."','".$_POST["fix_price_b"]."'.'".$_POST["fix_price_c"]."' ";
$strSQL .=",'".$_POST["fix_price_d"]."','".$_POST["total_service"]."'.'".$_POST["total_price"]."'.'".$_POST["totals"]."') ";
$objQuery = mysql_query($strSQL) or die (mysql_error());
if($objQuery)
{
echo "ํSAVE success";
}
else {
echo "Error Save [".$strSQL."]";
}
mysql_close($objConnect);
?>
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 '.'' ,'',''.''.'')' at line 1 มันเออเร่อแบบนี้อะครับ