Php, MySql - Multiple DB connections and mysql_insert_id()

Question

I have 2 database connections, and I want to get the last inserted ID from one of the connections.

$old_database = mysql_connect('host', 'username', 'password');
mysql_select_db('database1', $old_database);

$new_database = mysql_connect('host', 'username', 'password',true);
mysql_select_db('database2', $new_database);

$sql=mysql_query("INSERT INTO `table1`",$new_database);
$newid = mysql_insert_id();

Do I need to specify anything in the mysql_insert_id() function? I've been running into retrieving the last known ID, and I think it's due to this.

Community · Accepted Answer · 2023-11-17 20:38:18Z

3

Yes you need to specify the MySQL Resource Link Identifier, see: https://www.php.net/manual/en/function.mysql-insert-id.php

Like this:

$sql = mysql_query("INSERT INTO `table1`",$new_database);
$newid = mysql_insert_id($new_database);

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered Jul 20, 2010 at 22:02

bimbom22

4,5102 gold badges35 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Php, MySql - Multiple DB connections and mysql_insert_id()

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related