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 return many results if $_GET['search'] is very small like one
letter.
Good Luck,
Frank
On 2/24/04 8:20 AM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> From: "Nitin Mehta" <[EMAIL PROTECTED]>
> Date: Tue, 24 Feb 2004 13:18:24 +0530
> To: <[EMAIL PROTECTED]>, "-{ Rene Brehmer }-" <[EMAIL PROTECTED]>
> Subject: Re: [PHP-DB] how 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] how to do query on partial field contents ???
>
--
Frank Flynn
Poet, Artist & Mystic
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
