Multiple table update

Ask about general coding issues or problems here.

Moderators: egami, macek, gesf

Post Reply
New php-forum User
New php-forum User
Posts: 10
Joined: Fri Oct 18, 2002 8:07 am

Tue Oct 22, 2002 8:32 am

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


Tue Oct 22, 2002 1:18 pm

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

Post Reply