Auto insert record

[CatchItBaby]

I have 2 tables
Register (email , username , pass )
Userprofile ( email , userimage)

I want that if user register then email from register table automatically insert into the userprofile table

is it possible ?

and i don't want to fire 2 querryr at register button

Thanks

[jmcilhinney]

Duplicating data like that is a bad idea. You should have a column in the secondary table that can store the primary key from the primary table. That's a foreign key. If you need data from both tables you execute a query with a join.