PDO Problem

[Enlightened]

Hello,

I cannot manage to use LIKE in my mysql query, it will return no results,

Ive tried everway of '%$var%' known and it returns nothing, however it will work if i do the same query through phpmyadmin.
Im running The latest apache, php and mysql.

PS. It will work if i just do WHERE field = field (no LIKE)

 
<?php 
 $search = "'%" . $_POST['search'] . "%'"; 

 $stmt = $db->prepare( "SELECT * FROM docs, keywords WHERE keywords.keywords LIKE :search" ); 
 $stmt->bindParam( ":search", $search ); 
 $stmt->execute(); 
 $row = $stmt->fetch(); 

 // Returns 0 

 echo $search; // '%cis%' 

 /* 

 SELECT * FROM docs, keywords WHERE keywords.keywords LIKE '%cis%' 
  in phpmyadmin returns stuff 
 */ 

 ?>

[dbchip2000]

Looks like http://us2.php.net/manual/en/function.pdostatement-bindparam.php#61505 is an encounter of a similar issue

[MarkR]

Lose the single quotes in the parameter value. Otherwise, the above should work.

A placeholder can only be used for a SINGLE, COMPLETE parameter, however it should work fine with LIKE.

If you're in any doubt what's being sent to the DB, enable MySQL query logging to see.

Mark

[bradgrafelman]

Try replacing the single quotes with double quotes around the search pattern.