[netcoweb]

Probably not the best place to post, but here it is.

I'm trying to build a computer builder page that uses products in stock to build your own computer for my site. I want it to only display products that are compatible with other products. Say when I add a motherboard as a new product, i want to be able to say it accepts Socket A processors supports up to 3.2 ghz, 5 pci slots, agp 8x/4x, ddr 400/300 blah blah blah. Then it will populate the processor field with compatable processors, 5 different fileds for pci slots. Anyways i know this is a pretty easy task and that I can do it with querys which im not really good at. I just need to be pointed in the right direction. How would I go about doing querys to the database to find something like this:

Find all motherboards that support amd duron

DATA
-------------
AMD Athlon XP/Athlon/Duron
AMD Athlon/Duron
AMD Athlon XP/Duron
Intel P4

Then it would display:
AMD Athlon XP/Athlon/Duron
AMD Athlon/Duron
AMD Athlon XP/Duron

I'm not sure what to look for.

1 more question

In a form, how can i add new items on the fly without loosing all the data i already entered.

Say I'm entering all the specs for a motherboard and theres a new item athlon xp 64 bit, heres an example.

AMD
---------
0 Athlon XP
0 Athlon
0 Duron
Add Item:__________ Update

When i get to part where i dont have an option to check something, i want to be able to add it on the fly and check it and not loose all the data I entered above this part. I know i can do this with javascript but im not sure what function to look at. I've been out of the programming loop for a while so I need a little refreshing, well you can say a lot because it's pretty basic stuff. I got everything down on paper how i want it pretty much but little stuff like this keeps my mind in a loop as far as how to do it.

Thanks in advanced, any links or sample code would help.

Gabe