Re: [PHP-DB] Re: Multi search function (help)

2004-05-31 Thread Ng Hwee Hwee
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 =

RE: [PHP-DB] Re: Multi search function (help)

2004-05-28 Thread Gavin Amm
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

Re: [PHP-DB] Re: Multi search function (help)

2004-05-27 Thread nabil
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

Re: [PHP-DB] Re: Multi search function (help)

2004-05-26 Thread Ross Honniball
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