Hi
Just want some advice on how to do the below:
I already have one table called ‘venopt’ which has two fields one is ‘id’ and ‘venues’
I also already have a table for members details called ‘ptdata’ and has ‘id’ ‘firstname’ and ‘surname’ etc
Both ids in each table are primary keys and autoincremented.
The user will be selecting options from the ‘venues’ table and submitting them via POST.
How should i then handle the data, is it best to setup another table which will store the selections and if so how would i go about that?
Or is it best to store the details in an array say in the ‘ptdata’ table.
Either way I would also want to retrieve the contents of the array and display it in another drop down list?
Any ideas