hi.. your should just use if (empty($foo)) statements.. i did my search
scripts like that too and they were wonderful!
PS: besides $query, all the $variables are being posted from a form...
$query = "select * from myTable where ";
$query .= (!empty($typeS)) ? "Column1 =
r script
(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 s
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)
>
> Als
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 t