Automatically insert

[L4DD13]

Hi guys,

I have 2 tables related to users:
'users' this contains all the commonly used information like username, password, etc.
'user_details' which contains other details like location, dob, forename, etc.

What I want to happen is when a user registers and has their details inserted into users a record is automatically created within user_details.

Is this possible without having to create a separate queries for the user table and user_details table?

Thanks.

[tripy]

Yes, by using a trigger.
Look there for examples and explanation on how to use them
http://dev.mysql.com/doc/refman/5.0/...e-trigger.html

[r937]

will there ever be more than one row in user_details for each row in users?

if not, they should be combined, and then you don't need to do anything

[L4DD13]

Yes, by using a trigger.
Look there for examples and explanation on how to use them
http://dev.mysql.com/doc/refman/5.0/...e-trigger.html

Thank you for the link.

will there ever be more than one row in user_details for each row in users?

if not, they should be combined, and then you don't need to do anything

There will only be one row for each user, so I will combine them.



Thanks.