Board index   FAQ   Search  
Register  Login
Board index php forum :: php coding PHP coding => General

Multiple table update

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

Multiple table update

Postby Jacques » 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
Jacques
New php-forum User
New php-forum User
 
Posts: 10
Joined: Fri Oct 18, 2002 8:07 am

Postby Jay » 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
Jay
 


Return to PHP coding => General

Who is online

Users browsing this forum: Bing [Bot] and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron