|
I understand what you are trying to do... I think...
If I am correct, you will have your user information in one table and the band profile information in another table. I'll assume that all members will have a record in the user table, and only those who choose to create a profile will have a record in the bandprofile table.
The easiest way to accomplish what you are trying is to create a field in the "user" table called something like "band_profile_id". This should be allowed to be NULL but should likely be an integer.
In the bandprofile table, you have to create a field called id or for convenience sake, "band_profile_id" and make this an integer also, but set it as a KEY and make it "Auto Increment". Then add a field called "username" that is the same configuration as the "username" field from the users table.
Now, when you update your records in each table, you can "cross-link" the users in the users table to the proper "band_profile_id" and vice-versa, you can link the band profiles to the proper username.
Once your tables are cross-linked, you can use SELECT FOR and UPDATE WHERE queries to properly pull records and/or update them from your forms.
You will have to modify the script extensively to accomplish what you are trying to do, and while I would love to help you out it is no quick task and unfortunately I don't have a lot of free time. I hope you are familiar enough with PHP and SQL to use the tips above to work this out on your own...
I'll keep an eye on this post if you need additional help, let me know.. I'll help when and how I can.
Mike.
|