Shop by Designer

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rssajkow
Forum Newbie
Posts: 11
Joined: Mon Oct 02, 2006 1:03 am

Shop by Designer

Post 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
Post Reply