title: having trouble with a query
body: <p>I am trying to return rows for pet depending on the available values for country, province and city. I have tried putting %country%, %province%, %city%...</p>
  
  <pre><code> WHERE
   pet LIKE "Grey parrot"
   AND
  (country LIKE '$country'
   or province LIKE '$province'
   or city like '$city' )
  </code></pre>
  
  <p>I also tried this:</p>
  
  <pre><code> WHERE
   country LIKE '$country'
   or province LIKE '$province'
   or city like '$city'
    AND (pet like 'Grey parrot')
  </code></pre>
  
  <p>if values for $country...then return all Grey parrots in that country...</p>
  
  <p>if values for $country and $province then return all Grey parrots in that country and province.</p>
  
  <p>if values for $country, $province, $city then show all Grey parrots in that country, province and city.</p>