title: SQL PHP Placeholder Used More Than Once
body: <p>I'm creating a form with a single search field and I want that field to query against 3 different sql columns (think album titles, track names, and artists).</p>
  
  <p>This is the code that I'm trying to make work...</p>
  
  <pre><code>$search = "%".$_POST["sermon"]."%";
  $stmt = $dbh-&gt;prepare("SELECT * FROM dbo.TblSermon WHERE (Series LIKE :search) OR (Sermon LIKE :search) OR (Speaker LIKE :search) ORDER BY Sermon ASC, Date ASC");
  $stmt-&gt;bindParam(':search', $search);
  $stmt-&gt;execute();
  </code></pre>
  
  <p>This is the error that I get...</p>
  
  <blockquote>
    <p>SQLSTATE[07002]: [Microsoft][SQL Server Native Client 10.0]COUNT field incorrect or syntax error</p>
  </blockquote>
  
  <p>From all the tutorial I've seen, placeholders aren't meant to be used more than once (each field should have its own).  Is there a way to get this to work?</p>
  
  <p>JJ</p>