Get id for row inserted

[vikaspa]

Dear Please help me

 

I am inserting a  records in a table

 

I want to know the id for the row inserted which is auto generated

 

How can i get it

 

Please please help

[zenag]

$sql=mysql_query("insert into ....);

echo mysql_insert_id();

 

gives the id of the row inserted.

[jana]

as a mysql query u can use

select last_insert_id();

as in php u can u as zenag said

[gluck]

as a mysql query u can use

select last_insert_id();

as in php u can u as zenag said

 

Make sure you get id right after the insert else if someone else fires an insert before you did the select you might get wrong results.