generating web pages from DB content

I am having some trouble with where to start as far as generating web pages from a db for instance I have a category and subcategory then a range of products for each sub category how can I generate these pages on the fly from my DB. Does anybody know of any tutorials or have some advice.

 

thanks

 
...