Posted by jmark on 06/22/07 14:29

On Jun 22, 6:56 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> j...@fastermail.com wrote:
> > 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?
>
> The point being that Pear DB is obsolete. See
> <http://pear.php.net/package/DB>.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -

Thanks to you two, I will migrate to mdb2

[Back to original message]