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