|
|
Posted by Jerry Stuckle on 06/22/07 11:56
jmark@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.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|