Error: You have an error in your SQL syntax;

Question

I still encounter errors.

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 'comcode, version, classification, location, availability, date, client) VALUES ' at line 2

  <?php
    $host="localhost"; // Host name 
    $username="user1"; // Mysql username 
    $password="test123"; // Mysql password 
    $db_name="inventory"; // Database name 
    $tbl_name="cisco"; // Table name

    mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
    mysql_select_db("$db_name")or die("cannot select DB");


    $con = mysql_connect("localhost","root","");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    mysql_select_db("inventory", $con);


    $addcisco="INSERT INTO cisco
    (critical_spare_id, serial_no, ,comcode, version, classification, location, availability, date, client)
    VALUES ('". $_POST['critical_spare_id'] . "', '" . $_POST['serial_no']. "', '". $_POST['comcode'] . "','". $_POST['version'] . "','". $_POST['classification'] . "','". $_POST['location'] . "', '". $_POST['availability'] . "', '". $_POST['date'] . "', '". $_POST['client'] . "')";


    mysql_query($addcisco,$con);

    if (!mysql_query($addcisco,$con))
      {
      die('Error: ' . mysql_error());
      }
    echo "1 record added";

    mysql_close($con);

    ?>

[Consider reading this.](http://stackoverflow.com/a/601524/29995) — Rob Hruska, Apr 30 '12 at 03:37

score 2 · Accepted Answer · answered Apr 30 '12 at 03:35

2

You've got an empty column name in your insert statement:

(critical_spare_id, serial_no, ,comcode, version,

                              ^

answered Apr 30 '12 at 03:35

Rob Hruska

118,520
32
167
192

Error: You have an error in your SQL syntax;

1 Answers1