retreiving auto-incremented id's

[heaps21]

hi,
I have a table with an id that increments automatically whenever a new row is inserted. After I have inserted a new row, I then need to obtain the id for the row I have just inserted. Is there any function that can do this, or if not, any suggestions as to how I should do it?
Cheers

[heaps21]

sorry

sorry, only just read the sticky at the top of the page !!