MySQL Error - "You have an error in your SQL syntax" on insert

Question

The error message I'm getting:

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 'INSERT INTO accounts(balance, interest) VALUES(0, 1.5)' at line 4 in INSERT INTO accounts(id_user, interest) VALUES(73, 'Savings'); INSERT INTO balance(balance, interest) VALUES(0, 1.5)

My PHP code is:

$query = "INSERT INTO accounts(`id_user`, `type`)
          VALUES($userid, '$type');

          INSERT INTO balance(`balance`, `interest`)
          VALUES(0, $interest)";

My first guess that something was wrong with my query, so I tried to run the exact same query in phpMyAdmin and it worked perfectly.

Any suggestions on what might be wrong ?

You are probably using an interface function that only allows a single statement rather than a compound statement. — Gordon Linoff
– Gordon Linoff, Commented Dec 1, 2015 at 23:08

bassxzero · Accepted Answer · 2015-12-01 23:26:55Z

2

Gordon Linoff is correct.

From the great manual in the sky.

"mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier. "

http://php.net/manual/en/function.mysql-query.php

change

$query = "INSERT INTO accounts(`id_user`, `type`)
          VALUES($userid, '$type');

          INSERT INTO balance(`balance`, `interest`)
          VALUES(0, $interest)";

to

$query = "INSERT INTO accounts(`id_user`, `type`)
          VALUES($userid, '$type');";
result = mysql_query($query);

$query="INSERT INTO balance(`balance`, `interest`)
          VALUES(0, $interest)";
result = mysql_query($query);

answered Dec 1, 2015 at 23:26

bassxzero

5,01924 silver badges36 bronze badges

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

Comments

Drew · Accepted Answer · 2015-12-01 23:59:10Z

2

Are you using mysqli to run this ? I suspect you are running two queries in a single statement, you need to use mysqli_multi_query function to execute multiple queries at the same time.

Mysqli Manual page on multi_query

edited Dec 1, 2015 at 23:59

Drew

25k10 gold badges47 silver badges81 bronze badges

answered Dec 1, 2015 at 23:15

thepiyush13

1,3211 gold badge8 silver badges9 bronze badges

Collectives™ on Stack Overflow

MySQL Error - "You have an error in your SQL syntax" on insert

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