MySQL - retreiving last 'row' added - n/m solved

[PaulC2K]

Hi,

I've had this before, gone through post history and a few sites ive built where i might have used this and cant find it.

Say ive just added a new peice of information to my table, i know theres a simple way of requesting that peice of info so i can get its auto-incremental ID number given to that row. That way i can then take that ID and pass it onto another table without having to search for the information i've just submitted.

Thx,
PaulC2K

[PaulC2K]

nevermind, what a n00b, couple of minutes later and i spot what im looking for on the previous from where i was looking!

mysql_insert_id();