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
PROTECTED]
tel. 0121-242-1473
---
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: 28 March 2002 17:21
To: MySQL
Subject: SQL query question - using LIKE
I have a simple search form that allows the user to search
---
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: 28 March 2002 17:21
To: MySQL
Subject: SQL query question - using LIKE
I have a simple search form that allows the user to search a
contact db
based on criteria that they choose
---
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: 28 March 2002 17:21
To: MySQL
Subject: SQL query question - using LIKE
I have a simple search form that allows the user to search a
contact db
based on criteria
: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 variable;
}
And if none of the fields have been filled out I'll return an error
msg.
As you mentioned, Peter's logic