Hi guys.. I've been thinking on something for a little while and I need some advice. I am inserting several fields into a table, however there's an 'id' (id integer not null auto_increment) column that I use as the primary key. the problem lies in the fact that I want to get the 'id' that was generated from this insertion. However the data I insert has no unique value apart from the 'id' field itself how should I go about retrieving the id number ? Thanks :) Tom