Running two MySQL queries at a time in PHP mysql_query()

Question

I need to use SELECT LAST_INSERT_ID() function of MySQL to get the ID of last inserted row. When I try to run this:-

  mysql_query("
    INSERT INTO `posts`
           (`user`, `body`, `time`, `pageID`)
           VALUES('pachykutty', 'testMessage', '2012-10-26 04:59:43', 1);
    SELECT LAST_INSERT_ID();");

Gives me error, but When I run the two queries separately like this:-

mysql_query("
INSERT INTO `posts`
       (`user`, `body`, `time`, `pageID`)
       VALUES('pachykutty', 'testMessage', '2012-10-26 04:59:43', 1)");
mysql_query("SELECT LAST_INSERT_ID()");

It is OK. I fear that If two clients ran the query same time, their LAST_INSERT_ID will conflict. So I want to run the two queries together without delay. Is there any way?

LAST_INSERT_ID is maintained per connection.

Eelke
– Eelke

2012-10-26 05:28:34 +00:00
Commented Oct 26, 2012 at 5:28 — Eelke
– Eelke, Commented Oct 26, 2012 at 5:28
possible duplicate: stackoverflow.com/questions/6821184/…

WebChemist
– WebChemist

2012-10-26 05:52:16 +00:00
Commented Oct 26, 2012 at 5:52 — WebChemist
– WebChemist, Commented Oct 26, 2012 at 5:52

Lalit Jain · Accepted Answer · 2012-10-26 05:24:32Z

3

You can use query like that

mysql_query("
INSERT INTO `posts`
       (`user`, `body`, `time`, `pageID`)
       VALUES('pachykutty', 'testMessage', '2012-10-26 04:59:43', 1)");
$var =  mysql_insert_id();

mysql_insert_id acts on the last performed query.

So no worries and use above code.

answered Oct 26, 2012 at 5:24

Lalit Jain

1367 bronze badges

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

2 Comments

itsfarseen Over a year ago

Thank you very much for the info. But one doubt. I have on actions.php

itsfarseen Over a year ago

Thank you very much for the info. But one doubt. I have on actions.php in which scripts.php is included. Scripts.php contains function like insertPost($user,$body,$page); which will automatically do validation of data. All posted data is sent to actions.php and insertPost function is called. If i call mysql_insert_id() in actions.php - neither in insertPost() function nor inside scripts.php - Can I still get the correct value,no conflicts with other users?

Collectives™ on Stack Overflow

Running two MySQL queries at a time in PHP mysql_query()

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related