title: best practice for multiple select fields?
body: <p>I don't want to post the PHP code yet because I really don't think I have the best way of doing this.</p>
  
  <p>Anyway here is what I am looking to accomplish.</p>
  
  <p>I have a "classlist" table that has instructor led class information - including region and classtype.</p>
  
  <p>I have "regions" table and a "classtype" table.  Right now people are able to choose their region or classtype from a drop down - works great.</p>
  
  <p>But they want the option to choose multiple regions and classtypes - and these have to be search/sortable.  So when someone logs on they only see classes in their region by default.</p>
  
  <p>I have created a helper table "regionhelper" that has fields - regionhelperid, regionid, and classlistid.  I am able to add multiple regions to a class -- works great.  </p>
  
  <p>But I would like the end-user to be able to see a select box with all of the regions and by them choosing 3 of the 12 regions they would update 3 rows on the regionhelper table.  Right?  </p>
  
  <p>If my process behind this is right how do I update multiple rows at once on a different table?  </p>