ECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: 28 March 2002 19:16
Subject: Re: SQL query question - using LIKE
> DL -
>
> Points well taken -
> I am using php and doing simple validation
> EX - if ($fname !="") {
> add fname string to search variabl
%"';
>> if($loan_officer)$query.= ', AND Loan_officer LIKE
>> "%'.$loan_officer.'%"';
>> etc.
>>
>> $mysql_result = mysql_query($query, $mysql_link);
>>
>> HTH
>>
>> Peter
>>
>> -----------
>
eter
>
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> www.sunmaia.net
> [EMAIL PROTECTED]
> tel. 0121-242-1473
> --
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
> -Original Message-----
> From: Mark Stringham [mailto:[EMAIL PROTECTED]]
> Se
I have a simple search form that allows the user to search a contact db
based on criteria that they choose.
Search by -
first name - text box
last name - text box
region - drop down
loan officer - drop down
I want the user to be able to receive results if they choose all possible
criteria or jus
