title: Mysql WHERE clause not working?
body: <p>I've looked at a bunch of articles on here but I can't find quite what I'm looking for </p>
  
  <pre><code>SELECT SUM(adult) as adult_sold_1 WHERE showtime = '1'From tickets
  </code></pre>
  
  <p>Everything here works but when I try to use WHERE the entire thing stops working...</p>
  
  <p>What's wrong with this?</p>
  
  <p>EDIt:</p>
  
  <p>Also is there a way to do multiple at once??</p>
  
  <p>Like </p>
  
  <pre><code>SELECT SUM(adult) as adult_sold_1 From tickets WHERE showtime = '1' 
  </code></pre>
  
  <p>then the same thing with student in spot of adult?</p>