items set up by color

Ray

In my items table i have a field 'itemOptionGroup' it is an index and an item would have a value of 1, 2, or 3


This is Options table

OptionID itemOptionGroup OptionName

1 1 White

2 1 Bronze

3 1 Royal Brown

4 1 Forest Green

5 2 Bronze

6 2 Almond

7 3 White

8 3 Bronze



my sql is

$query_rs_raingutters = "SELECT * FROM items, Options WHERE items.itemOptionGroup = Options.itemOptionGroup AND items.itemCatID = 3";



i have a repeat region to show 10 results

In the region is 4 dynamic text and 1 list/menu

In a browser it shows the same item 30 or more times and times out?

As a test, I removed the list/menu and the browser shows without timeing out. An item that has 4 colors, shows 4 times, item with 3 colors, shows 3 times, and so on?


Don't know if the problem is in my sql or the way i have my tables set up?


thanks for any help

jim balthrop