A page that gives me a category with products
eg

SHIRTS
yellow
red

The yellow and red lines are hyperlinks. If you click on yellow it will take you to a Results page that shows all the yellow shirts that you can choose to see. Lets say that there are 4 yellow to choose from and 3 red when you get to these respectable pages. What I cannot figure out to do is to have the initial page show me the following:

SHIRTS
yellow(4)
red(3)

Anybody know how to do this?

Cleo

Sure you know how to do this. On the 1st page all that happens is there is some kind of syntax that checks the databse to see how many yellow shirts are in there and then it gives you the value in ().

I looked at someone elses source. I tried to do the same thing but I only came up with an empty (). Got the color of () that I wanted too. Heres what the code looks like on the other guys site

<a name="Prints" href="SearchForCat.asp?cat=1704">Prints</a> <font size=2 font color=#808080>(492)</font></font>

492 is how many of these prints are in the DB. Looking at something alse that I stole from somewhere, but I cannot find at the moment (I think I have it on another computer) I remember seeing that it had something to do with the VTI_Group

Im sure you either have done this or can figure it out

Cleo

This is how Id do it

"SELECT COUNT(*) as fldCount FROM Table WHERE Color in ('Yellow','Red') GROUP BY Color"