duplication of queries

Anon

i am making a program to store the name of some companies in the database and their information, now i am trying to access the company names form the database, but if a company has two entries with same names but different products , its accessing the name of the company twice ,

how can i prevent this duplication?

Can anyone please help me out ??

thanks

Anon

add an abstraction layer...

table company(
comp_id
comp_name
prod_lookup_id
);

table prod_lookup(
prod_id
prod_lookup_id
);

table products(
prod_id
prod_name
);

And to get all companys you do
"SELECT comp_name FROM company;"
that should get you all company names all unique, and to get all products from company with company id 5 do this:

"SELECT products.prod_name FROM products, prod_lookup, company WHERE company.comp_id = 5 AND company.prod_lookup_id = prod_lookup.prod_lookup_id AND products.prod_id = prod_lookup.prod_id;"

That will give you the name of all products for that company... get it??

Andreas