Love2c0de Posted May 6, 2014 Share Posted May 6, 2014 Good afternoon, How would I handle inserting checkboxes into a mysql database? I have a form which has a list of services in checkbox format as well as other fields and I want to save the values to a database but I want to be able to query the database by service if needs be. How do I deal with multiple services from checkboxes? Would I create another table called 'services' for example with columns - 'service1','service2','service3' etc etc and a unique id relating to my contact table? Thank you for your help. Kind regards, L2c Quote Link to comment Share on other sites More sharing options...
Barand Posted May 6, 2014 Share Posted May 6, 2014 You would have three tables Contact contactid | contactname | etc Service serviceid | servicename | etc ContactService id | contactid | serviceid ContactService would contain a row for each service offered by each contact Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.