is LAST_INSERT_ID() better then

redzzzon

LAST_INSERT_ID() better then mysql_insert_db().

Seems these type of fuctions are important when a schema has to be updates but is not discussed much. Why is that and is there a way without these functions?

Thanks Tom

Drakla

You mean the php function mysql_insert_id() compared against the mysql function LAST_INSERT_ID() yeah?

Well basically the php version is a wrapper for the other, so why waste time doing

mysql_query('INSERT SOMETHING');

$res = mysql_query('SELECT LAST_INSERT_ID()');

$row = mysql_fetch_row($res);

$insertID = $row[0];

When you can just do

$insertID = mysql_insert_id();

jkurrle

It is my understanding that if your auto incrementing index is set to Big_Int instead of Integer, then you need to use last_insert_id() instead of mysql_insert_id() to avoid errors.

So, basically if you just want the last transaction ID in an integer based auto incrementing column, then this should be fine:

<?php $trx_id=mysql_insert_id(); ?>

If your column is Big_Int, however, you need to use the following:

<?php
$select="select last_insert_id()";
$result=mysql_query($select)
or die("Last ID select failed");
$row=mysql_fetch_row($result);
$trx_id=$row[0];
?>

Any comments?