title: IN statment on a MySQL INNER JOIN php pdo
body: <p>i have an array i want to implode, then pass to a query and spit out all the matching values, but all i get is a <code>1064 violation</code>, im sure its some silly syntax i've missed. </p>
  
  <pre><code>$filmImplode = implode("','", $filmList);
  $query = "
      SELECT
          watch.film_id,
          films.film_api_id
      FROM
          watch
          INNER JOIN films ON films.film_id = watch.film_id
      WHERE
          films.film_api_id IN ('$filmImplode')
          AND watch.user_id = :user_id";
  $query_params = array(':user_id' =&gt; 1);
  try {
      $stmt = $db-&gt;prepare($query);
      $getWatched = $stmt-&gt;execute($query_params);
  } catch (PDOException $ex) {
      echo 'something went wrong' . $ex-&gt;getMessage();
  }
  $getWatched = $stmt-&gt;fetchAll();
  </code></pre>
  
  <p>The SQL error reads </p>
  
  <p>something went wrongSQLSTATE[42000]: </p>
  
  <blockquote>
    <p>Syntax error or access violation: 1064 You have an error in your SQL
    syntax; check the manual that corresponds to your MySQL server version
    for the right syntax to use near
    'item0','item1','item2','itme3','item4' at line 3</p>
  </blockquote>