How to fix this MySql syntax error in PHP?

Dilini

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);

?>

Jenson M John

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.

edited at
0

Comments

0 comments
Login to comment

Related

TOP Ranking

  1. 1

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  2. 2

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  3. 3

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  4. 4

    pump.io port in URL

  5. 5

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  6. 6

    BigQuery - concatenate ignoring NULL

  7. 7

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  8. 8

    Do Idle Snowflake Connections Use Cloud Services Credits?

  9. 9

    maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

  10. 10

    Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

  11. 11

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  12. 12

    Generate random UUIDv4 with Elm

  13. 13

    Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

  14. 14

    Is it possible to Redo commits removed by GitHub Desktop's Undo on a Mac?

  15. 15

    flutter: dropdown item programmatically unselect problem

  16. 16

    Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

  17. 17

    EXCEL: Find sum of values in one column with criteria from other column

  18. 18

    Pandas - check if dataframe has negative value in any column

  19. 19

    How to use merge windows unallocated space into Ubuntu using GParted?

  20. 20

    Make a B+ Tree concurrent thread safe

  21. 21

    ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

HotTag

Archive