In that case you can do something like this:
$s_where = '';
foreach (array('name', 'lastname', 'nickname') as $e)
{
$s_where .= (!empty($s_where) ? ' AND ' : '' ) . (!empty($_REQUEST[$e]) ?
$e='$_REQUEST[$e]' : '' );
}
$result = mysql_query(SELECT id, name , lastname , m_date from users .
(that generates the sql statement) regarding how many form fields you
have every time you add a new form field to the form page.
Gav
-Original Message-
From: nabil [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 May 2004 10:57 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Multi search function
yes, this is true, we should add empty() function too.
Ross Honniball [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I'm not 100% sure, but you may want to also check if the field is empty
(using empty() function) before including in your search. (in addition to
isset)
Also, just
Nabil wrote:
hi all
Is there a way to condition your search:
-I have a form for four text boxes for search my Mysql...
-I don't want to write 4 conditions and for SQL statements incase he
decided not to search with all keywords (fields)
- I have by example : name, lastname ,
thanks .. but my question is not for isset... i m thinking consider that i
have 10 search fields... if i have to do a combination then i need a day to
right the various SQL statements
David Robley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Nabil wrote:
hi all
Is
Nabil wrote:
David Robley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Nabil wrote:
hi all
Is there a way to condition your search:
-I have a form for four text boxes for search my Mysql...
-I don't want to write 4 conditions and for SQL statements incase he
I'm not 100% sure, but you may want to also check if the field is empty
(using empty() function) before including in your search. (in addition to
isset)
Also, just a caution, you will need to take some care in figuring when and
where to place your 'and' statements linking the various parts of
