[phppick]

HI,

I am doing some Dynamic Reporting. For sample lets say, in the Filter Window (Parameter Passing Window), I have,

1.Branch (All, B1, B2, B3, B4)
2.Applicant Type (i.e All, Bachelor, Masters)
3.Gender (All, Male,Female)
4.Religion (All, Christian, , , )
5.Country (All, ....)
6.Marital Status(All, Married, Single, Divorced)

User have many options to choose, before he/she click 'Search' to View Results.
Example 1: Select (Branch) B1, Male, Single (M.Status), All (Country)
Example 2: Select (Branch) All, Female, All (M.Status), UK (Country)

How to Write a sample & Compact Query for this type.. insted of writing so many queries..

Any Ideas.

Thanks
Jen

[dennispopel]

Hello,

I don't know why do you thinks this is difficult: just use several select boxes in the form and then just build single query like:

$sql = "SELECT * FROM tableName WHERE 1=1 " .
(($x = $_GET['branch']) ? " AND branch='$x'" : "") .
(($x = $_GET['type']) ? " AND type='$x'" : "") .
(($x = $_GET['gender']) ? " AND gender='$x'" : "")

and so on.