storing multiple text details in a single table field
Posted: Tue Mar 08, 2005 2:48 am
Hi all;
I have a certain problem regarding storing numerous variables and then being able to extract them from the column.
THe issue is as follows, It's just that I cannot figure out how to send the values to a single field, I need to concatenate the fields into a single string and then be able to seperate them and their particular values, and use them once seperated. I thought about using XML but am not too sure how to do that. If I could get any assistance I'd really appreciate it.
The particular part of the system works as follows:
1) When a user types names into additional text fields (which could be any amount) I need to store them in a single field in a table's column. These values need to have some sort of clear seperator so that when I retrive the info from a mySQL database using php functions, PHP will be able to say that textbox1 value= 'blah and textbox2 value = 'blahblah' and so on and so forth no matter how many field details he adds.
2) I also need to be able to assign multiple values to any of these values.
For instance if a user adds a new text field, and if he tells that text field to have a drop down option the text field needs to store multiple values for that text field.
Many thanks for any assistance with this issue.
I have a certain problem regarding storing numerous variables and then being able to extract them from the column.
THe issue is as follows, It's just that I cannot figure out how to send the values to a single field, I need to concatenate the fields into a single string and then be able to seperate them and their particular values, and use them once seperated. I thought about using XML but am not too sure how to do that. If I could get any assistance I'd really appreciate it.
The particular part of the system works as follows:
1) When a user types names into additional text fields (which could be any amount) I need to store them in a single field in a table's column. These values need to have some sort of clear seperator so that when I retrive the info from a mySQL database using php functions, PHP will be able to say that textbox1 value= 'blah and textbox2 value = 'blahblah' and so on and so forth no matter how many field details he adds.
2) I also need to be able to assign multiple values to any of these values.
For instance if a user adds a new text field, and if he tells that text field to have a drop down option the text field needs to store multiple values for that text field.
Many thanks for any assistance with this issue.