updating multiple tables

[crawfd]

I have a registration form, ..and what I need to do is save portions of the form into seperate tables, but keep the users id the same. This is a result of some db normalization I worked on, ....when a user registeres his/her information must be divided into seperate tables but maintain the same id. Then later on I can pull their info by just referencing an id and using a join.

My question is, how would I write a query that updates two tables? Would I have to use two seperate queries and pass the first id to the second query somehow? Perhaps someone could give me an example, thanks.

[vectorian798]

I am assuming you have some sort of UserID field that is common to multiple tables.

You store this ID in a variable in your PHP code. Then you simply have three different queries with the appropriate data from your form in each. Then run all three and all your tables are updated.

AFAIK, there is no single query to update multiple tables.