title: retrieve multiple records from one table
body: <p>I have a table that displays interests. Each interest has an ID. At the moment the query just brings back one person for one ID. Its basically a filter on the website that sorts the results by interests.</p>
  
  <pre><code>$catwhere = " and e.person_id IN (select escint_person from person_interests_person where escint_person = e.person_id and escint_interest = 26) ";
  </code></pre>
  
  <p>I would like it to display the results from multiple interests. </p>
  
  <p>So in my basic logic it would look like this</p>
  
  <pre><code>$catwhere = " and e.person_id IN (select escint_person from person_interests_person where escint_person = e.person_id and escint_interest = 26,27,28,29) ";
  </code></pre>
  
  <p>but obviously this doesn't work. </p>
  
  <p>Any help would be appreciated.</p>