I am sure this has been asked before...sorry if it has.

I am making a page that when you submit it, based upon static criteria in 3 seperate listboxes/menu boxes on the first page will produce a query to a second page with the results.

For example:
List Box 1 is name Letter, List Box 2 is age, List Box 3 is Gender...

Whatever you choose in the 3 boxes will give you the outcome on the second page. So based upon that criteria, if you chose Letter A, age of 22, Gender of Female... it would give you those results from an Access/MySQL DB. All names starting with the letter A who is 22 and is female.

I have never done anything like this and would like to get into the advance arena of this type of web design.

Can either someone help me with the code or give me a webpage which explains how this is done? I am not looking for handouts, but it's something that is driving me up a wall. ASP101 didn't seem to have anything and I am not familiar with other good sites. Any help would be great. Thanks.

BTW...does adding Pictures in a DB cause a quicker corruption in data in a DB?

hi!! you can do it with following query to your database

consider you collect three values as follows

nameChar = Request.Form("Listbox_1")
age = Request.Form("Listbox_2")
gender = Request.Form("Listbox_3")

query will be as follows

"Select * from [TABLENAME] where [NAMECOLUMN]='"&nameChar&"%' and [AGECOLUMN]="& age&" and [GENDERCOLUMN]='"& gender&"'"

Here I considered age datatype as number

According example given by you it will be

"Select * from [TABLENAME] where [NAMECOLUMN]='A%' and [AGECOLUMN]=22 and [GENDERCOLUMN]='female'"