Update multiple rows/columns in php/mysql

Question

I have the following line:

$reset = "UPDATE pidgeon SET obt='" . $hour . "' WHERE tag='" . $tag . "'";

Which updates just fine. However I need to update an additional row (kill) and I keep getting syntax errors. I've tried the following:

$reset = "UPDATE pidgeon SET obt='" . $hour . "', kill='1' WHERE tag='" . $tag . "'";

$reset = "UPDATE pidgeon SET kill='1', obt='" . $hour . "' WHERE tag='" . $tag . "'";

$reset = "UPDATE pidgeon SET obt='" . $hour . "', kill='" . $num . "' WHERE tag='" . $tag . "'";

I've even done 2 separate UPDATE queries and I get the same syntax error message. I've narrowed it down to the system having issue with the kill row but I'm not sure what's the issue. I've tried setting kill as INT, SMALLINT, BOOL, even CHAR and trying to use 't/f' as values for it. I still get a syntax error. Any suggestions?

possible duplicate of Syntax error due to using a reserved word as a table or column name in MySQL — michaelb958--GoFundMonica
– michaelb958--GoFundMonica, Commented May 7, 2014 at 0:16

Amal · Accepted Answer · 2013-12-22 18:09:47Z

1

KILL is a reserved keyword, so you'll have to enclose it in backticks, like so:

$reset = sprintf("UPDATE pidgeon SET `kill`='1', obt='%s' 
WHERE tag='%s'", $hour, $tag);

answered Dec 22, 2013 at 18:09

community wiki

Amal

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

2 Comments

Amal Over a year ago

@AlexP: Absolutely. It's always better to use a more descriptive column name.

xv47 Over a year ago

You are the best! Thank you so much! Its always the silliest errors.

Ahmed Siouani · Accepted Answer · 2013-12-23 14:20:37Z

0

Kill is actually a syntax, you can't use them directly.

Just replace kill with another name.

edited Dec 23, 2013 at 14:20

Ahmed Siouani

13.9k12 gold badges63 silver badges73 bronze badges

answered Dec 22, 2013 at 18:12

Kirk

5,0852 gold badges35 silver badges63 bronze badges

Collectives™ on Stack Overflow

Update multiple rows/columns in php/mysql

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related