How to construct an SQL query?

From: Wassim <net2000_at_francemel.com>
Date: Sun, 13 Jun 1999 23:04:41 GMT
Message-ID: <7k1de5$a29$1_at_nnrp1.deja.com>

Hi,
suppose that i have a form like this :
name :
[Quoted] [Quoted] date : from [ ] to [ ]

[send] [cancel]

i want to know how to construct the SQL query while i can't be done only [Quoted] dynamically because criteria of search are only known after submission [Quoted] of the form, search can be on 'name' only, or 'name'+'from_date' or the [Quoted] 3 criteria..

Have i to do it using UNION between 2 or 3 SELECT query? Thanks for help !!

Wassim,
e-mail: net2000_at_francemel.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 14 1999 - 01:04:41 CEST