title: How to write a Doctrine Query with multiple conditions?
body: <p>I am trying to write a doctrine query that meets the following conditions:</p>
  
  <pre><code>published = 1
  AND 
  subsection = "gui" OR "lvo" OR "tnn" OR "wer"
  </code></pre>
  
  <p>This is what I have:</p>
  
  <pre><code>$getPrograms = Doctrine::getTable('Program')
    -&gt;createQuery()
    -&gt;where('published=?', '1')
    -&gt;andWhere('subsection=?', 'gui')
    -&gt;orWhere('subsection=?', 'lvo')
    -&gt;orWhere('subsection=?', 'tnn')
    -&gt;orWhere('subsection=?', 'wer')
    -&gt;orderBy('title ASC')
    -&gt;execute();
  </code></pre>
  
  <p>This is pulling the correct subsection records, but is pulling records all published records, instead of only ones set to 1.</p>
  
  <p>I feel I need to isolate the two conditions ( this AND (this OR this OR this)) but I do not know how.</p>