Forums

PHP

This topic is locked

Dreamweaver MX recordset

Posted 10 Aug 2003 16:05:43
1
has voted
10 Aug 2003 16:05:43 Rob Rocket posted:
I have the following tables:

PROD
prodid | prodname | proddesc
1815 | Hat | Patriotic Hat....

COLORS
prodid | color
1815 | Red
1815 | White
1815 | Blue


When I join these tables in my recordset my result is

RECORDSET
prodid | prodname | proddesc | prodid | color
1815 | Hat | Patriotic Hat....| 1815 | Red
1815 | Hat | Patriotic Hat....| 1815 | White
1815 | Hat | Patriotic Hat....| 1815 | Blue

How do I get this to display in DW as follows:

1815 - Hat
Patriotic Hat
Red, White, Blue

I don't want this displayed 3 times, once for each color, but rather as the
one item with the 3 possible colors listed. Thanks.

Reply to this topic