retrieve images from the database

I created my own page grabbing the top 2 products per manufacturer and I would like to display the product image with the name and short description I pulled from the Products table.  How can I grab the correct image and detail button URL?

I am not sure if you want a thumnail or a fullsize picture, but I just copy the existing code. If you want to display a thumbnail, I just look at the code in /Modules/HomePageProducts.ascx. If you want to display a fullsize picture, I use the code in /Modules/ProductInfo.ascx. You can just leverage the code to meet your needs.

Tod