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, "php-db-digest-help@xxxxxxxxxxxxx"
<php-db-digest-help@xxxxxxxxxxxxx> wrote:
> From: "Nitin Mehta" <nitinmehta@xxxxxxxxxxxx>
> Date: Tue, 24 Feb 2004 13:18:24 +0530
> To: <php-db@xxxxxxxxxxxxx>, "-{ Rene Brehmer }-" <metalbunny@xxxxxxxxxxxxxx>
> Subject: Re: 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 }-" <metalbunny@xxxxxxxxxxxxxx>
> To: <php-db@xxxxxxxxxxxxx>
> Sent: Tuesday, February 24, 2004 11:57 AM
> Subject: 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
