Problem in Returning the last insert id?

[radiations3]

I am using the following code to return the last insert id from the table employee kindly let me know what is wrong with the following code:

<?php

$temp_array = mysql_query("select last_insert_id() from employee");

 

//now you can display it, to test it

echo $temp_array;

?>

[radiations3]

its not returning any value....

[AbraCadaver]

its not returning any value....

 

mysql_fetch_array() ?

[radiations3]

On the following code

 

<?php 
$temp_array = mysql_fetch_array(mysql_query("select last_insert_id() from employee")); 
$my_last_id = $temp_array['last_insert_id()'];
//now you can display it, to test it 
echo $my_last_id ; 
?>

 

following error is occuring:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\DBMS\untitled.php on line 10

[Pikachu2000]

PHP has a built in function for that: mysql_insert_id. If you need to use the MySQL LAST_INSERT_ID() function directly, read the manual entry for it. Your syntax is off.

[radiations3]

How to use  mysql_insert_id() to retrieve the last id from the table employee

 

KINDLY HELP!!!???

[radiations3]

HELP ANY1??

[radiations3]

cANT ANYONE SOLVE THIS ISSUE???? 

[AbraCadaver]

PHP has a built in function for that: mysql_insert_id. If you need to use the MySQL LAST_INSERT_ID() function directly, read the manual entry for it. Your syntax is off.

[radiations3]

PHP has a built in function for that: mysql_insert_id. If you need to use the MySQL LAST_INSERT_ID() function directly, read the manual entry for it. Your syntax is off.

 

How to use  mysql_insert_id() to retrieve the last id from the table employee

 

KINDLY HELP!!!???

[AbraCadaver]

OK, since it's kind of vague.  The id it returns is not table specific.  It is for the last successful insert query.  Not foolproof, but if you need it for a specific table you might do:

 

SELECT MAX(id) FROM employee

[radiations3]

OK, since it's kind of vague.  The id it returns is not table specific.  It is for the last successful insert query.  Not foolproof, but if you need it for a specific table you might do:

 

SELECT MAX(id) FROM employee

 

Besides above mentioned method....Can anyone kindly guide me how can i return my last id to use  mysql_insert_id() from the table employee

 

KINDLY HELP!!!???

 

[radiations3]

Does any body knows how to do it???

[TeNDoLLA]

You can't as already mentioned in the posts above, mysql_insert_id() returns the ID from the last query u ran in your scripts. To get the latest row in some table you should use:

SELECT * FROM some_table ORDER BY id DESC LIMIT 1

 

[radiations3]

Thanx ALL!!!!