Multiple table update

[Jacques]

I am playing with a membership database.

I have 2 tables

freemembers: id,user,pass,address
approvedmembers: if,user,pass,interest

Once a member has been approved I would like him/her to be able to update his/her info held on both tables using one form.

I can do one table at the time. I understand mysql does not allow it. Is there a way php might?

Thanks a million

[Jay]

You can update as many tables as you like with one form, you just have to write in your script for it to do so. There's nothing stopping you. Just do a separate insert for each