Forums
This topic is locked
posting multiple checkboxes to one db field
Posted 06 Nov 2005 23:35:22
1
has voted
06 Nov 2005 23:35:22 Andrew Shanks posted:
Hi guys, I was wondering if its possible to lay out a form like the following (checkboxes instead of the dashes), and get all the values to update the one field in a database:
What are your hobbies (tick all that apply)?
- surfing
- bodyboarding
- wakeboarding
- kitesurfing
- windsurfing
so what I'd want if I ticked surfing and kitesurfing above is that in the hobbies column of my database, under my name it would list surfing, kitesurfing (I've built a logon routine, and update page and everything works except doing mulitple values to one destination. I have gone down the road of getting the form to update a whole pile of individual fields, i.e. H_SURF, H_BBOARD, H_WKBOARD, etc, but then I can't get my search page to search for something like, "who here surfs" and "lives on the west coast"
Any help would be greatly appreciated as I'm a bit of a newbies and this is doing my head in.
Cheers,
andrew
Edited by - cavekid on 06 Nov 2005 23:45:42