correct use of mysql insert id

[rulian]

hey, i'm trying to look for the id generated by my insert command without having a second query, so I use mysql_insert_id to do that, my book tells me the format is :
mysql_insert_id([link_id])but I cant get it to work, i'm confused by the [link_id] part;
example, lets say my insert is
$insert=mysql_query("INSERT INTO ....");

I tried $num=mysql_insert_id($insert); wrong format
I tried $num=mysql_insert_id([$insert]);
wrong format, how would I do this?

[Anon]

Hi

the linux_id is your connection to the database..

Look at the $sql variable in the example below

$sql=mysql_connect("localhost","webmin","*****") or die("Unable to connect to SQL server");

$DB="webadmin2";
mysql_select_db($DB,$sql) or die("Unable to select database");

$query = 'insert into TEST (ID,NAME) values(NULL,"Great")';
if ( ! mysql_db_query($DB,$query,$sql) )
{
/* Error handling
}

$insert_id = mysql_insert_id($sql);

[[deleted]]

The link_id is the connection-identifier returned by mysql_connect().

$db = mysql_connect(bladebla);
mysql_query('insert bla', $db);
echo mysql_insert_id($db);

[Anon]

BTW, whatever is in square brackets is optional. The manual describes what the default value is when you don't provide the parameters in brackets.

mysql_insert_id([link_id])

In this case, the default link_id is the last one you used.

[[deleted]]

"BTW, whatever is in square brackets is optional."

Correct, but I urge everybody to put the link identifier in always. Not just when you are using more than one connection.

You can get into serious trouble should you ever include/require another script/class that also uses a database connection.

[Anon]

Good point. Omitting bracketed parameters could make expansion / growth more difficult than it needs to be.