Update Query Error using php

Question

hi to all m using the following query:

$rows = mysql_query("UPDATE admin SET create ='".$close."' WHERE id=".$id) or die(mysql_error());

but i got the following 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 'create ='0' WHERE id=6' at line 1

help me plz in this regard thnx in advance

@KA_lin Don't you mean BEGIN it...

nickhar
– nickhar

2012-10-12 14:52:04 +00:00
Commented Oct 12, 2012 at 14:52 — nickhar
– nickhar, Commented Oct 12, 2012 at 14:52

Marc B · Accepted Answer · 2012-10-12 14:49:59Z

8

create is a reserved word. You'll have to escape it:

UPDATE admin SET `create`=...
                 ^-     ^-

answered Oct 12, 2012 at 14:49

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

2 Comments

AliMohsin Over a year ago

i have change the query $rows = mysql_query("UPDATE admin SET 'create' ='".$close."' WHERE id=".$id) or die(mysql_error()); but the error is same

Marc B Over a year ago

wrong quotes. use backticks: ` . normal quotes, ' turn things into strings.

Matt Humphrey · Accepted Answer · 2012-10-12 14:54:55Z

2

You need to quote your query correctly with backticks (`) as create is a reserved keyword in MySQL.

$rows = mysql_query("UPDATE admin SET `create` = '".$close."' WHERE `id` = ".$id) or die(mysql_error());

I highly recommend using PDO.

edited Oct 12, 2012 at 14:54

answered Oct 12, 2012 at 14:49

Matt Humphrey

1,5541 gold badge12 silver badges30 bronze badges

6 Comments

Marc B Over a year ago

id doesn't need to be quoted. it's not a reserved word.

Matt Humphrey Over a year ago

True but it's consistent. I would always use PDO anyway.

Matt Humphrey Over a year ago

Actually, yes you are right. I was thinking of ORM behaviour! Still PDO is the way forward.

AliMohsin Over a year ago

i have change the query $rows = mysql_query("UPDATE admin SET 'create' ='".$close."' WHERE id=".$id) or die(mysql_error()); but the error is same

Matt Humphrey Over a year ago

You are using the wrong type of quoting. You should be using backticks `. Copy my code posted in the answer.

|

Collectives™ on Stack Overflow

Update Query Error using php

2 Answers 2

2 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related