Named placeholder in PDO?

[Mr Chris]

Hello all,

 

This is driving me potty.  I'm trying to run a query in PDO that a pass to a function.

 

function myFunction ($dbc,$the_date) {
  echo $the_date;
  $QUERY = $dbc->query("SELECT * from table WHERE the_date = ':the_date' ORDER BY id DESC");  
  $QUERY->bindParam(':the_date', $the_date);
  $QUERY->setFetchMode(PDO::FETCH_ASSOC);  
//etc...
}

 

Now as you can see I echo $the_date and it shows, but when the query runs the named placeholder does not seem to work.  When I take the WHERE clause out it works fine, so I know it's not an issue there.

 

Any thoughts?

 

Thanks

[PFMaBiSmAd]

prepare, bindParam, and execute are used together and used with replaceable parameters/placeholders, not with the query method.