Mysql query help

[d_barszczak]

Hi all,

 

This is probably very simple but i can't for the life of me figure this out.

 

I have an auto increment on one of my columns labled 'id' that i use as an unique id fro each of my records. Is there anyway when i insert a record into my database i can find out which 'id' has been given to it.

 

Thanks.

[fenway]

Yes, LAST_INSERT_ID().

[d_barszczak]

Thanks,

 

cant find LAST_INSERT_ID() on php.net but this seems to do the same thing.

 

mysql_insert_id()

 

Is this the same function or am i not looking hard enough?

[fenway]

the former is the mysql function, the latter is the php function.

[d_barszczak]

Ok so here is an example of my query. I understand how i could use the php function but how would i iplement the mysql function.

 

$query = "INSERT INTO (username, password, email, enabled) VALUES ('admin','pass','[email protected]','1'); ";

 

Which would be the prefered method and why?

[fenway]

They're exactly the same, the php function just wraps it.