Basiacally I have two MySQL tables: Manufacture Applications
My manufacture table has a list of manufacturers
examples: Sony, Philips, Sanyo
My applications table has a list of applications.
examples: Televisions, DVD Players, Telephones
I want to be able to choose certain application - Televisions - and then display results from the manufactures that make televisions. My problem would be simple if only 1 manufacture made televisions, but I have multiple manufactures for each application.
I thought of creating a feild in the applications table called "manufactures" and then have all the ID's of each manufacture seperated my commas. But I can't get any further.
Can anyone help? I can help back
Thanks in advance!
Corey