hexica

Hi guys/gals, I built a simple php/mysql database for the job listing pages on a medical recruitment website [a href=\"http://www.mediplacements.com\" target=\"_blank\"]http://www.mediplacements.com[/a] ). It's very basic but works fine, so they are happy. At the moment any job can only be in 1 area because of the diversity of each area. They now want to create a seprate website purely for the care worker section of the business. The trouble is, each job needs to be in several different areas. For example a job for social work in London would fit both 'social work' area, and also 'elders' area. The immediate thought was to have tickboxes for all the areas on the job submit page - then I realised I don't have a clue how the hell I could send the data into the mysql database! So basically - using tickboxes how do I get the results into a database? I could do it a very long way round so each tick box has its own colomn in the joob database, and ticked=1, not ticked =0 - but isnt this a long winded way to do something relatively simple? Any help or pointers greatly apreciated!