i have a questionnaire im creating in dreamweaver, now on one of hte questions they have the option to select more than one box. e.g days of the week how can i get that to be stored in the databae im using under a particualr field if that makes sense. e.gfield 1 will store monday,tuesday,thursday. etc

hope you can help

A Select box with the multiple attribute set.

Or check boxes

these are checkboxes.

So what actually is your question?

The server code?

A database structure?

There are many possible solutions. You could have one field for each day in the database, or you could have one field and use a special structure to represent each day. You could i.e. use a 7 digit char field where 0 means that day is excluded and 1 means it's included.

So '0000000' would mean no days were selected, '1111111' means all days were selected and '0000011' means only weekend (if first digit mean monday).

what im meaning is when the data is stored to the database the field will show that the following has been selected: monday,tuesday,wednesday,friday

so basically all the boxes that the user has ticked for that question are keeped in a single field rather than several.

hope this makes a litltle more sense.

A single field is NOT a good idea for such a scenario. Yes it will be simple to implement BUT it WILL create problems at later stages.

What if someone asks for "all records" for "Friday" it means your search routine is going to have to do some manipulation (slow) on a column to extract those records.

Use a separate table with a PK - FK relationship.

EG:
user/record ID as the linking column and a daynumber column

and just run a JOIN query.

ok i will try what you suggested once the questionnaire has been completed the only thing that will be happening later on is i will export ther results to a CSV later on so they can see whats been filled in. There wont be any other things done with it.

It would be nice just once in a while to get ALL the relevant information at one go, so we could give the best possible answer.

If it is a "one shot" data collection with no sorting needed just store all the data in a single field as a CSV.