php/sql question - how to build a dynamic query statement based on user input

[NotGiven]

I need to build a query based on what the user checks in the form. For
example, if the user does not check certain fields, I don' tneed to use
those in the query statement.

Any ideas how to build this? Thanks.

[Virgil Green]

Re: php/sql question - how to build a dynamic query statement based on user input

"NotGiven" <noname@nonegiv en.net> wrote in message
news:amdMc.1693 5$GT3.1008@bign ews6.bellsouth. net...[color=blue]
> I need to build a query based on what the user checks in the form. For
> example, if the user does not check certain fields, I don' tneed to use
> those in the query statement.
>
> Any ideas how to build this? Thanks.
>[/color]

if, elseif, and concatenation