mysql returning index number

[Anon]

Hi,

Is there a way to get the newly created index number back from mysql after adding a new record?

Thanks

Richard

[aleczapka]

there is a mysql function which does it

LAST_INSERT_ID()

so use it with select toghether and do the query on you db

"SELECT LAST_INSERT_ID()"