getting the last value inserted

Ulysses_Freeman

Been a while since i've been here, and not much has changed on my end. I'm still a newbie at all this stuff.

Curious though, I have a database setup with MySQL. My first column is an auto_incremented column called INDEX. Now, what i need to do is get the last value incremented in the column.

I don't really have to much code, but this is what i have thus far and IT DOES NOT WORK.

$sql = "INSERT INTO pro_calls_answer ($insert_value) VALUES ($dbOption[0])";
$dbi=mysql_query($sql) or die(mysql_error());

$qry = mysql_query("select last_insert_id() from pro_calls_answer"); 

$lastid = mysql_result($qry,0);

Now from my understanding, using last_insert_id should tell me the last number that was inserted into INDEX column. But it doesn't. And I don't know how to do a sequence like in Oracle.

Any suggestions?

Thanx in advance
Ulysses

tomhath

Try calling mysql_insert_id() instead of the query and result.

http://www.phpbuilder.com/manual/function.mysql-insert-id.php

Ulysses_Freeman

Originally posted by tomhath
Try calling mysql_insert_id() instead of the query and result.

http://www.phpbuilder.com/manual/function.mysql-insert-id.php

My friend,

you are correct, that worked brilliantly!

Thanx
Ulysses