Re: Mysql PDO statement with params in HAVING problem

$stmt = $dbh->prepare("SELECT concat(first_name,' ',last_name) as
full_name,t.* FROM `specialists` `t` HAVING full_name like '%:query%'");

How about '%:$query%' instead of '%:query%' ? Does that solve the problem?

Thanks,



On Thu, Jun 27, 2013 at 5:21 PM, Alexander Pletnev <
[email protected]> wrote:

> Hi everyone, im new here, so please correct me if i created or formated
> topic incorrectly.
>
> I found a problem. I have a simple query for my needs:
>
>     $stmt = $dbh->prepare("SELECT concat(first_name,' ',last_name) as
>     full_name,t.* FROM `specialists` `t` HAVING full_name like '%john%'");
>     $stmt->execute();
>     while($row = $stmt->fetch())
>     {
>        echo '<pre>'; var_dump($row); echo '</pre>';
>     }
>
> It works fine, until i add a param to my query:
>
>     $stmt = $dbh->prepare("SELECT concat(first_name,' ',last_name) as
>     full_name,t.* FROM `specialists` `t` HAVING full_name like
> '%:query%'");
>     $stmt->execute();
>     $query = 'londo';
>     $stmt->bindParam(':query',$query);
>     while($row = $stmt->fetch())
>     {
>        echo '<pre>'; var_dump($row); echo '</pre>';
>     }
>
> Now there is nothing in fetch(). Is it a bug ?
>
> Thanks.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>