Allie,
From what I saw, you are creating a single php script for each top level product grouping (akileinecooling.php, etc.) This doesn't seem very efficient. Why not just pass the ID of this top level group and retrieve the associated products from one script. It might make your life a little easier.
As for your question, when you say "table" I assume you are referring to a database table. If so, then you should create a MANUFACTURER table and, on the PRODUCT table have the MANUFACTURER_ID as a foreign key to the MANUFACTURER table. Then, if you insist on createing a PRODUCT_ADDITIONAL_INFO table, you would have the PRODUCT_ID as a foreign key (If it is one to one and all products have additional info, I would just add these columns to PRODUCT table, but that's just me).
So, in order to get info from the MANUFACTURER table and PRODUCT_ADDITIONAL_INFO table for a selected product, it would something like this (assuming you pass the product id to it):
select pai.description,man.company_name
from PRODUCT_ADDITIONAL_INFO pai, MANUFACTURER man, PRODUCT prd
where prd.product_id = $_POST['product_id']
and pai.product_id = prd_product_id
and prd.manufacturer_id = man.manufacturer_id
That should get you what you want, assuming I even understadn what you are saying in the first place.
amc
