Category List

I have created database function for management, now I want to display the results to the end user in a controlled fashoin.
Created a page displaying available categories and number of posts
I was able to create the query to group categories and totals but how do I now using this product link them to a results page by category.
I know how to do it by manually coding to pass variables to a results page, but is there away to automate this procedure using ASPRUNNER?
HERE IS MY SQL STATEMENT:

SELECT COUNT(Category) AS Total, Category FROM inventory GROUP BY Category