INSERT Statement after a SELECT in mysql_query

Question

I'm trying to execute two SQL statements in one mysql_query.

$mySql = mysql_query("SELECT itemid, points FROM items WHERE id='1' UPDATE accounts SET userpoints = '1000'");

Is this possible? Thanks!

score 3 · Accepted Answer · answered Mar 10 '09 at 17:35

3

You can only execute one query in mysql_query (even if you seperate the queries with the semicolon terminator).

You have to call them seperately (although this guy has a method to automate that).

answered Mar 10 '09 at 17:35

Ross

score 2 · Answer 2 · answered Mar 10 '09 at 18:21

2

If you use mysqli you can use mysqli_multi_query()

answered Mar 10 '09 at 18:21

Tom Haigh

A better solution - if you're using PHP5 take advantage of MySQLi! – Ross Mar 10 '09 at 18:23
Be carefull with that though, MySQLi is **even more susceptible to SQL injections**, because it allows this kind of code: http://stackoverflow.com/questions/332365/xkcd-sql-injection-please-explain – Johan May 28 '11 at 21:32

score 0 · Answer 3 · answered Mar 10 '09 at 17:38

0

I wouldn't try doing that since you won't be able to exploit the results from the different queries (returned values, mysql_insert_id(), ...)

answered Mar 10 '09 at 17:38

Gad

3 Answers3