[PHPwestoz] getting the last inserted id in mysql

[Mike Fewings <mikework@strikeone.com.au>]

Hi all,

> Unfortunately I don't know any function in MySQL that lets you 
> retrieve the auto-increment ID of a field you just created. You 
> normally have to do another select, which is not hard if you do this: 
> "SELECT ID FROM Artists ORDER BY ID DESC LIMIT 1" This will give you 
> the last created ID, which normally would be the last record you created.


This function can retreive the last insert id from the database

               select last_insert_id() as feild_id

and make this query immediately after the insert and it will return the 
last id that was inserted by auto increment.

Cheers
Mike Fewings