Help Request - display result of search on two criteria

[mrking]

Hi,

I am relatively new to PHP. I can get by, but....

I have a mysql database with 4 fields each and this is what I want to do.

I want to be able to search a database based on two criteria and then display the result to those items that fit the criteria.

The two tables are:

Frames
Lights

The 4 fields in both tables are:

name,color,size,weight

each of those fields have all the corresponding data in them.

I would like to be able to create a sort via drop down menus with a GO button and display the results.

So in the first menu a user would select between FRAMES or LIGHTS

in the next menus they would select the options they wanted to sort by.

For example, colour and size.

if colour=red AND size=5
then display name

Of course the colour and size perameters would change each time some other variable is select.

Would someone here be able to help me on this?

Regards,

Michael