I know it wouldn't be long before I was back. I have a dilemma and really have no idea where to look for an answer. I have two issues going on and I appoligize in advance if I'm wrong for putting them both into one single post.
My first question has to do with more of a design issue than anything else.
I have an html form that will be populated with data from a mysql database using php. My *insert* form has the basic name, address, phone number information. I am starting to wonder how my form will insert more than one phone number or even customer location.
Say a customer has 15 (Highly unlikley but for example sake) telephone numbers. My insert form needs to have a list of fields that will allow the person to enter those numbers. I'm looking for a clean design. Can someone give me any pointers as to how this should be done?
My tables are like this:
Expand|Select|Wrap|Line Numbers
- customer_table
- customer_ID
- customer_Name
- customer_Location_table
- customer_Location_ID
- customer_ID
- address1
- address2
- city
- state
- zip
- customer_Phone_table
- customer_phone_ID
- customer_Location_ID
- phone_Type
- area_Code
- phone_Number
Expand|Select|Wrap|Line Numbers
- Customer Name
- Address1
- Address2
- City
- State
- Zip
- Phone Type
- Area Code
- Phone Number
- [SUBMIT BUTTON]
The only way I can see to add another phone number would be to place an insert new button next to all of the fields that can have *many* of one thing such as customer location, phone number what have you but this design tenique does not strike me as clean.
I would ultimately like to have "one" submit button that will enter everything in one shot.
My second question has to do with SERIALIZABLE transactions. Is this hard to set up? Do I need to set up the entire db to use them? Again, just advice. Thanks Guys!
Frank