title: Many to Many Join Query in CodeIgniter
body: <p>All previous attempts at a JOIN have left me with either the disc or item data populating the id, title keys of the result (maybe a clash is occuring).</p>
  
  <p>So I have:</p>
  
  <pre><code>item table
  fields: id, title
  
  disc table
  fields: id, title
  
  item_disc table
  fields: item_id, disc_id
  </code></pre>
  
  <p>How do I construct a double join so that I can access the related discs to an item. At present I am running two seperate queries, one for a single item record, then one for array of discs.</p>
  
  <p>Apart from it being easier to do in one query with joins, if I ever want to retrieve more than 1 record, I would currently need to be running 2 queries per item as I cannot join my data.</p>
  
  <p>Please help!! I feel this is my final many to many hurdle (though dare not speak too soon).</p>