I'm making data installing form and trying to save those data in db.
And I'm getting this given below error.
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 'desc, total) VALUES ('MM20', '520.00' , 'S.Hashan' ,'522.00' , 'hgASKCHkbzmbk' ' at line 1
Actually I'm sending six records. 'MM20', '520.00' , 'S.Hashan' ,'522.00' , 'hgASKCHkbzmbk' ,'5200.00' But only five is sending as the error showing. Given below is my source code. Please help me.
<?php
$con = mysql_connect("localhost", "root", "");
if ($con) {
$db = mysql_select_db('mobile', $con);
} else {
die('Could not connect: ' . mysql_error());
}
if (array_key_exists('save_data', $_POST)) {
$model_no = mysql_real_escape_string($_POST['model_no']);
$service_fee = mysql_real_escape_string($_POST['service_fee']);
$sp_name = mysql_real_escape_string($_POST['sp_name']);
$sp_price = mysql_real_escape_string($_POST['sp_price']);
$desc = mysql_real_escape_string($_POST['desc']);
$total = mysql_real_escape_string($_POST['total']);
$query ="INSERT INTO mobile_rep (model_no, service_fee, sp_name, sp_price, desc, total)
VALUES ('{$model_no}', '{$service_fee}' , '{$sp_name}' ,'{$sp_price}' , '{$desc}' , '{$total}')";
$result = mysql_query($query);
if ($result) {
echo "1 record added";
} else {
echo "error";
echo '<br/>'. mysql_error();
}
}
mysql_close($con);
?>
Modify Your Query :
$query ="INSERT INTO mobile_rep (`model_no`, `service_fee`, `sp_name`, `sp_price`, `desc`, `total`) VALUES ('{$model_no}', '{$service_fee}' , '{$sp_name}' ,'{$sp_price}' , '{$desc}' , '{$total}')";
DESC is Reserved word in MySQL. Reserved words are permitted as identifiers if you quote them.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments