Inserting multiple rows in mysql php

Question

I'm trying to insert multiple rows but I continue getting an sqlerror and cannot for the life of me figure out why.

 echo '"'.$thequery.'"'; $sql = mysql_query($thequery) or die(mysql_error()); return "SUCCESS";

$thequery gets printed out as: "INSERT INTO thistable (rank, change, reqID, vanID) VALUES (1,'PICKUP',28,1),(2,'PICKUP',29,1),(3,'DROPOFF',28,1),(4,'DROPOFF',29,1)"

and the 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 'change, reqID, vanID) VALUES (1,'PICKUP',28,1),(2,'PICKUP',29,1),(3,'DROPOFF',28' at line 1

Thanks in advanced.

@Justin Casing is not a reason for syntax errors.

glglgl
– glglgl

2011-08-26 05:50:56 +00:00
Commented Aug 26, 2011 at 5:50 — glglgl
– glglgl, Commented Aug 26, 2011 at 5:50

glglgl · Accepted Answer · 2011-08-26 05:50:12Z

1

CHANGE is a reserved word in MySQL. Rename the column or enclose the identifier in backticks.

Besides, you seem to have a typo in the VALUES part: in (1,'PICKUP,'28,1),(2,'PICKUP,'29,1),, the ,' should be ',.

answered Aug 26, 2011 at 5:50

glglgl

91.5k13 gold badges157 silver badges230 bronze badges

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

2 Comments

y3di Over a year ago

I fixed the apostrophe error and it didn't help. but i did change change to thistable.change and it worked, many thanks! What do you mean my backtick tho? Would it just be 'change?

glglgl Over a year ago

No, ' is no backtick. ` is one. You would write `change`.

Collectives™ on Stack Overflow

Inserting multiple rows in mysql php

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related