Mysql query syntax failing

Question

I've been trying to execute this mysql query in my php file however I think there may be a problem with it as I get an error whenever it reaches the code.

Here is the query:

"INSERT INTO " . $my_tableName . "(mycolumn, myothercolumn)
values ('myvariable', " . $pass . ");" .
"INSERT INTO " .  $my_othertableName . "(morecolumns) values ('morevalues');"

And here is the error:

SQLSTATE[42000]: Syntax error or access violation: 1064 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 ':)' at line 1";i:1;s:978:"#0

It seems you are trying to execute two sql statement on one line hence the "." between the queries. Secondly put a space after the quote joining the fields - $my_tableName . " (mycolumn... — Chibuzo
– Chibuzo, Commented Apr 5, 2012 at 22:57

barsju · Accepted Answer · 2012-04-05 22:55:41Z

2

Maybe you need to quote your $pass value:

"INSERT INTO " . $my_tableName . "(mycolumn, myothercolumn)
values ('myvariable', '" . $pass . "');" .

answered Apr 5, 2012 at 22:55

barsju

4,4561 gold badge23 silver badges24 bronze badges

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

Comments

DaOgre · Accepted Answer · 2012-04-05 22:57:24Z

1

In PHP you can't execute multiple insert statements separated with a ;. You need to execute these as separate queries. This is to prevent injection. Try running as 2 queries and it should work fine for you.

answered Apr 5, 2012 at 22:57

DaOgre

2,10016 silver badges28 bronze badges

Collectives™ on Stack Overflow

Mysql query syntax failing

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related