Page 1 of 1

Shop by Designer

Posted: Thu May 15, 2008 12:03 pm
by rssajkow
Hello all. I have a small clothing store for a client. Basically I was hoping I could make one MYSQL table with all the products, with fields like:

id, designer, title, description, price, sizes, colors, date_added

ON the home page, I want to dynamically build a "shop by designer" menu with text links. But I only want to show that designer's name if there are, in fact, products in the table by that designer. So my question is---- is there a way to list all the designers that currently have a stocked product or do I need a separate linked table for designers?

TIA

rob