RE: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Bastien Koert
PHP-DB] Question on the use of where statements Date: Wed, 1 Dec 2004 07:55:35 -0800 (PST) --- Bastien Koert <[EMAIL PROTECTED]> wrote: > so...best to build the statement dynamically and > execute it once only if the > input box has a value in it... > And that is the way I'm buil

RE: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Gryffyn, Trevor
AM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Question on the use of where statements > > > --- Bastien Koert <[EMAIL PROTECTED]> wrote: > > > so...best to build the statement dynamically and > > execute it once only if the > > input box has a v

RE: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Stuart Felenstein
--- Bastien Koert <[EMAIL PROTECTED]> wrote: > so...best to build the statement dynamically and > execute it once only if the > input box has a value in it... > And that is the way I'm building it. Just thinking about the scenario that somone actually chooses 75% of the options - would that po

RE: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Bastien Koert
(isset($_POST['fieldN'])){ $sql .= " and columnN = '".$_POST['fieldN']. "'"; $result = mysql_query($sql); ... bastien From: Stuart Felenstein <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] Question on the use of where statement

Re: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Stuart Felenstein
Sorry ..hit the wrong button --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: I posted this over on mysql list. Not trying to be redundant, but would like to get some feedback. Basically I'm wondering. I am creating a search form , dynamic query, that could potentially have in the area of 4

[PHP-DB] Question on the use of where statements

2004-12-01 Thread Stuart Felenstein
I posted this over on mysql list. Not trying to be redundant, but would like to get some feedback. Basically I'm wondering. I am creating a search form , dynamic query, that could potentially have in the area of 40+ where statements. i.3. 1- where x = y and -- PHP Database Mailing List (http: