Retrieve auto increment value 1

[white605]

When we insert a record with sql and the record has an autoincrement field for id how do we return the value of the id for us in the same script to enable us to select that same record back for further processing?
wjwjr

This old world keeps spinning round - It's a wonder tall trees ain't layin' down

 

[vacunita]

mysql_insert_id()



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[white605]

thanks for your swift reply, we are transitioning from in house vfp with record pointers and get stumped every once in a while.
wjwjr

This old world keeps spinning round - It's a wonder tall trees ain't layin' down