Hi you all...I hope someone can help me with this... For school I have a project in PHP, but i'm not very familiar with it. I have a working login system where the user data is inserted in a table called users. This table has an user_id which is auto_increment. After the user has logged in he can make choices (about a house he can design for himself)...How do I keep track of the choices a user makes??? The choices he makes are now inserted in a new table option...in this table is a option_id which is also auto_increment... For now I'm trying to put that option_id also also in the user table. Like that I think I can find a users choices with something like: SELECT option.livingtype FROM option,user WHERE user_id = 1 AND user.option_id = option.option_id This way i should find the choice of livingtype a user with user_id 1 has made or not?? How do i put the option_id (auto_increment) , which is generated by submitting the choices form not only in the option table but also in the users table??? Can anyone help me with this?? Thanks!!