I have a database called members. There is a table called members rides, Each member has a row that contains various information, such as what region (state) he/she is from. I want to display how many members there are in each state.<BR><BR> I can figure out one way to do it, but typing a connection to the database for a state, then closing it, opening it for a new state, 50 times over is not very practical.<BR><BR> What would be the best way of going about this? Some kinda loop or something?