title: MySQL query with multiple 'OR' statements
body: <p>I have a query, that I have tested outside of PHP directly on SQL and still getting the same problem</p>
  
  <p>The idea being that $currentArtist is sent through using the GET method, where this value matches the value in the <code>event_artist</code> columns the information is displayed.</p>
  
  <pre><code>SELECT 
              *
          FROM
              `".DBN."`.`events`
          WHERE
              `event_artist1` OR `event_artist2` OR `event_artist3` = '".$currentArtist."'
  
      ";
  </code></pre>
  
  <p>The problem I have is that it is completely ignoring the <code>WHERE</code> part of the query. It just returns the complete table results and not the results that match <code>$currentArtist</code>.</p>
  
  <p>I have tested <code>$currentArtist</code> and it works fine. I'm at a loss as to how to get the complete statement to work.</p>
  
  <p>I've tried surrounding the <code>OR</code> statements in brackets as in:</p>
  
  <pre><code>(`event_artist1` OR `event_artist2`...) = '".$currentArtist."'
  </code></pre>
  
  <p>This only returns a result if the <code>$currentArtist</code> is equal to "1" being the first person in the Artists table where their information is stored.</p>
  
  <p>Any help would be greatly appreciated.</p>