for partial match
like 'value' doesn't work, use
like '%value%'
Hop that helps
Nitin
- Original Message -
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 11:57 AM
Subject: [PHP-DB] how to do query on partial field contents ???
hi
to do query on partial field contents ???
for partial match
like 'value' doesn't work, use
like '%value%'
Hop that helps
Nitin
- Original Message -
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 11:57 AM
Subject: [PHP-DB
Frank Flynn wrote:
And if you'd like to make wild carding optional keep your code the way it
is:
$query .= AND `model` LIKE '.$_GET['search'].';
And put a comment on the web page Use the % for wild cards.
The thing about:
$query .= AND `model` LIKE '%.$_GET['search'].%';
Is it will
Too true - this is why a page that I promised would only take a few minutes
winds up taking all week.
But it makes steady employment for the QA team...
Frank
On 2/24/04 10:37 AM, Andy Armstrong [EMAIL PROTECTED] wrote:
Frank Flynn wrote:
And if you'd like to make wild carding optional
hi gang
I've mentioned this project before a couple of weeks ago ... just been busy
with school, so haven't had time to work on it that much
But anyways ... the test version is running here:
http://metalbunny.net/computers/cpudb.php
it's running with debug code, which should be obvious if