title: Using AND/OR mysql commands with FROM_UNIXTIME
body: <p>Trying to select a query in php/mysql to get "Upcoming Items" in a calendar. We store the dates in the DB as a unix time. Here's what my query looks like right now</p>
  
  <pre><code>SELECT *
  FROM `calendar`
  WHERE (`eventDate` &gt; '$yesterday') 
  OR (FROM_UNIXTIME(eventDate, '%m') &gt; '$current_month' AND `$yearly` = '1')
  ORDER BY `eventDate`
  LIMIT 4
  </code></pre>
  
  <p>This is giving me an error "Unknown column '' in 'where clause'". I'm sure it has to do with my use of parenthesis (which I've never used before in a query) and the FROM_UNIXTIME command.</p>
  
  <p>Can someone help me out and let me know how I've screwed this up?</p>
  
  <p>Thanks!</p>