unable to execute mysql query in php

Question

 $con = mysql_connect($server, $user, $password);
     if (!$con)
     {
     die('Could not connect: ' . mysql_error());
     }
     mysql_select_db($user, $con);
     $ref='444';
    $name="x7";
$quant =1;
    $price=7000;
    $sql=  "INSERT INTO order(ref_id, name, quantity, price, status) VALUES      ('$ref','$name','$quant','$price','pending')"; 
    if (!mysql_query($sql,$con))
     {
     die('Error: ' . mysql_error());
     }

This code is in php block. when i execute it i get this:

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 'order(ref_id, name, quantity, price, status) VALUES ('444','x7','1','7000','pend' at line 1

So any idea where i am going wrong? When I read the content of the table, it works fine thus proving that the connection and db is working fine. I am getting this problem whenever I try to populate a table. I am a Newbie in php and mysql :(. Please excuse me if the code contain a very silly mistake of mine :)

Hello, my name is using reserved MySQL words and it shot me in the foot. — N.B.
– N.B., Commented Nov 24, 2011 at 15:00
i solved it :D thanks guys. i changed the name of the table for good and its working normally. thanks again :D — Amit Mandal
– Amit Mandal, Commented Nov 24, 2011 at 15:04

Shakti Singh · Accepted Answer · 2011-11-24 14:59:02Z

5

order is a mysql reserved word you have to surround it with backticks `` like this

$sql="INSERT INTO `order`(ref_id, name, quantity, price, status)...

answered Nov 24, 2011 at 14:59

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ipr101 · Accepted Answer · 2011-11-24 14:59:16Z

1

order is a reserved word in mysql. It needs to be escaped using back ticks.

See - http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

answered Nov 24, 2011 at 14:59

ipr101

24.2k8 gold badges61 silver badges62 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:08:12Z

0

Try:

INSERT INTO `order`(ref_id, name, quantity, price, status) VALUES      ('$ref','$name','$quant','$price','pending')

this also can help: How can I make a table in MySQL called "order"?

edited May 23, 2017 at 10:08

CommunityBot

11 silver badge

answered Nov 24, 2011 at 15:02

idm

1,7482 gold badges19 silver badges26 bronze badges

Collectives™ on Stack Overflow

unable to execute mysql query in php

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related