MySQL Syntax Error from PHP When Executing Multiple Queries

Question

When I execute:

mysql_query("SELECT * FROM people WHERE fname = '$fname'; INSERT INTO people (first_name) VALUES ('$fname')") or die(mysql_error());

I receive this 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 'INSERT INTO people (first_name) VALUES ('Draski')' at line 1

Where is the syntax error?

You can only run one query with mysql_query(), not multiple. So, make it different function calls. Also, mysql_ is deprecated, for new code, please use mysqli_ or PDO. — Wrikken
– Wrikken, Commented Dec 18, 2013 at 2:01

Funk Forty Niner · Accepted Answer · 2013-12-18 02:11:11Z

2

You can't do run two queries in one statement with the mysql_* API. You will have to run them in two separate queries.

You can do it with mysqli_*, however. And since the mysql_* API is deprecated you should be using an alternative API like mysqli_* anyway.

edited Dec 18, 2013 at 2:11

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Dec 18, 2013 at 2:01

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

1 Comment

John AJ Over a year ago

Thanks, it worked. Will select as answer when I can.

voodoo417 · Accepted Answer · 2013-12-18 02:05:42Z

0

Use this function mysqli_multi_query for multiple queries.

answered Dec 18, 2013 at 2:05

voodoo417

12.1k3 gold badges39 silver badges43 bronze badges

Collectives™ on Stack Overflow

MySQL Syntax Error from PHP When Executing Multiple Queries

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related