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
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
--- 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
so...best to build the statement dynamically and execute it once only if the
input box has a value in it...
$sql = "select * from table where 1 ";
if (isset($_POST['field1'])){ $sql .= " and column1 = '".$_POST['field1'].
"'";
...
if (isset($_POST['fieldN'])){ $sql .= " and columnN = '".$_POST['
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
