hi, i have three tables: customer username classification the user will enter my web site enter the relevant customer details (which are transfered to the database) (s)he will then enter their prefered username, password and a password hint (again all sent to the database). once they are registered they choose between three classification types. i have used the mysql_insert_id () to obtain the customer_id from the customer table and to insert it into the username table, however i also need to insert it into the classification table but all i keep getting is 0. can anyone advise, is it possible? liz lynch