Posted by jmark on 06/22/07 05:20

On Jun 21, 2:42 pm, petersprc <peters...@gmail.com> wrote:
> On Jun 21, 3:00 pm, j...@fastermail.com wrote:
>
> > I need some assistance on how to create a select statement using PEAR
> > DB or MySQL with the LIKE function.
> > That is I am looking of how I can get statement like this work.
> > SELECT * FROM customer WHERE name LIKE '%?'
>
> require_once('MDB2.php');
>
> $mdb2 = MDB2::singleton('mysql://user:password@host/db');
> $mdb2->loadModule('Extended');
>
> $rows = $mdb2->extended->getAll(
> 'select * from customer where name like ?',
> null, array('%bob%'));

Thanks for the info. But currently I am running on PEAR DB. Is there a
way this can be done in PEAR DB or plain MySQL?

• Next in forum: How to get the redirected URL?
• Prev in forum: At what point should I implement validation?
• Thread view: Re: PEAR DB/MySQL Prepared Statement with LIKE

[Reply to this message]