Make Reports

[maskme]

Suppose I've Fields

Title
Age
Gender
Country

What I want is that a user selects either of these fields or all of these fields to get a report based on the selection.

For e.g.: A user selects age group from 18-21 & selects country USA, so from the database it will select those records only n give.

Firstly how should i know which of the above fields is selected.

e.g.

-------------------The below is for just one selection-----------------
if ($title != "") $var = "TITLE = $title"

$squery = "SELECT TITLE, AGE, GENDER, COUNTRY FROM tblparent where $var";

$sresult = mysql_query($squery) or die("Search Query Failed");

And if two or more of the fields are selected how should i put AND between them in the Query

Please help!

Yusuf

[xblue]

Hi,

there is no need to open multiple threads on the same subject. If you feel you did not explain your problem sufficiently, you can always either edit your original post or reply to it (and you actually can delete duplicates 😉).

Now, if you want someone to tell you how to access the values a user submitted in a form (this is what I understand?) it would be a good idea to post that form for a start.