Hi!
I want users of a web form to be able to type in multiple values into a 'child' mysql table for each entered value in a 'parent' table.
(For example, a number of lat-long positions for each research cruise. The cruise id is entered into a textbox, and underneath I'd like users to enter Lat+Long for each station that was visited during the cruise )
The values are not limited, and thus can't be selected from any listbox. The number of values to be typed in varies, also. Could I use a textarea, extract each row separately and then insert it into the mysql table?
Thanks in advance,
Maria
I want users of a web form to be able to type in multiple values into a 'child' mysql table for each entered value in a 'parent' table.
(For example, a number of lat-long positions for each research cruise. The cruise id is entered into a textbox, and underneath I'd like users to enter Lat+Long for each station that was visited during the cruise )
The values are not limited, and thus can't be selected from any listbox. The number of values to be typed in varies, also. Could I use a textarea, extract each row separately and then insert it into the mysql table?
Thanks in advance,
Maria