Need to populate 2 tables from one form, second table data not needed by user

[antonyfal]

Hi, im quite a newbie at .php forms but getting a handle on it..

I have a script which allows registered users to create a profile.. which later enables them to select information such as services they provide form a dropdown list.. The information from the dropdownlist comes from the table in my phpmyadmin called:

xxx_xxxx_services_classes

and the columns under this field are:

services_classes_uid , service_class_ abbv, services_classes_full_desc, image(can be 0), profile_uid(can be 0), srp_only(can be '0").

 

I have a working form in my admin section where i can populate this table with no problem, how ever i want the user to be able to add data themselves from the profile creation form.. The data does not have to link to the profile, it just has to populate the table above...

 

The profile creation form has several columns under the xxx_xxxx_profiles table...

 

Both forms work perfectly seperately, I would like to add multiple textboxes to the profile creation form so that when the submit button is clicked, both tables will be populated in phpmyadmin so that they will apear in the dropdown box on the redirect page where the user can select their services and add a more information in the new form.

 

I have an html frontend and a form script component for each form..

I think i just need to modify the profile creation form to be able to add the data to the Services table?

can someone help with the code? to enter the text boxes in the html, and the tables into the form..