Re: Newbie Help: Searching
| From: | Steve Brett | Date: | Thu, 06 Sep 2001 12:43:38 +0000 |
| Subject: | Re: Newbie Help: Searching | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12215@lists.php.net to get a copy of this message | ||
have 2 vars $Tech and $Admin and then chnage you SQL so it says:
>$Query = "SELECT * FROM enet WHERE TechContact LIKE '%$Tech%' AND
AdminContact
LIKE '%$Admin%'";
Steve
"Devon" <marty_e@hotmail.com> wrote in message
news:20010906024943.32493.qmail@pb1.pair.com...
> $Query = "SELECT * FROM enet WHERE TechContact LIKE '%' AND AdminContact
> LIKE '%'";
>
> This query simply prints out my entire tables, is there a way using PHP so
I
> can make the '%' a user input so they can search the table under those
> fields.
>
> Cheers
>
>