title: using same prepared statement parameter multiple times in a sql
body: <p>i'm trying to use a same parameter in my sql, but it's only recognizing the first. look my code:</p>
  
  <pre><code>$stmt = $dbh-&gt;prepare("SELECT
      (SELECT SUM(oq.value)
      FROM operations_quotas AS oq
          JOIN operations AS o ON oq.operation = o.id
      WHERE o.user = :user AND o.type = 1 AND oq.status = 1
      ) AS total_incomes_open,
  
      (SELECT SUM(oq.value)
      FROM operations_quotas AS oq
          JOIN operations AS o ON oq.operation = o.id
      WHERE o.user = :user AND o.type = 1 AND oq.status = 2
      ) AS total_incomes_wroteoff");
  
  $stmt-&gt;bindParam(":user", $this-&gt;getId());
  $stmt-&gt;execute();
  </code></pre>
  
  <p>is that possible?</p>