title: Codeigniter - Database select
body: <p>Hi,</p>
  
  <p>I need a help related to Codeigniter very badly.</p>
  
  <p>I have some problems with a database query, i'am new to Codeigniter.</p>
  
  <p>I have 3 tables:</p>
  
  <pre><code>1) film(film_id, filmname) PK (film_id)
  2) category(category_id, categoryname) PK (category_id)
  3) film_category(contains both primary keys (film_id) and (category_id))
  </code></pre>
  
  <p>The problem is that I want to <code>select all filmname from film tables where category_id = 3</code>.</p>
  
  <p>How to do this with active record class?</p>
  
  <p>Please make a suggestion.</p>
  
  <p>I'am new to Codeigniter and I love it.</p>
  
  <p>Thank you in advance from your friend.</p>