retrieving last auto _increment number

[natefanaro]

I have seen the LAST_INSERT_ID() function but for some reason it either will not work for what I am looking to do, or I was using it wrong. I am trying to get the last number that is given by the auto_increment number in mysql. But when I look for info on LAST_INSERT_ID(), it's always used in another sql query. I am trying to do something similiar to this: $lastid = LAST_INSERT_ID()

Here's an example of my current code:

$db = mysql_connect("localhost", "quizcrea_root"

mysql_select_db("quizcrea_quiz",$db);

$sql = "INSERT INTO results (email,name,num1,num2,num3,bcolor,tcolor) VALUES ('$email','$name','$num1','$num2','$num3','$bcolor','$tcolor')";

$result = mysql_query($sql);

// I tried adding this but it gives an error


$lastid = LAST_INSERT_ID()

//end code

any suggestions?

 

[danielhozac]

I think the function you want is mysql_insert_id(). It will return the index of the recently inserted record. //Daniel

 

[natefanaro]

Thanks, just tried it but it returned a value of 0.

// begin

$lastid = mysql_insert_id();
echo $lastid;

// end

So it doesn't look like it worked. any other ideas?

 

[danielhozac]

Read this:

http://www.php.net/manual/en/function.mysql-insert-id.php

//Daniel

 

[natefanaro]

nevermind, it works. thanks!