You mentioned that currently you have the site setup like this:
The first step will be creating a recordset to get the details for the products that you would like on the page. You would create the recordset by going to Server Behaviors > Recordset. If you do not know how to create recordsets or get them working you should take a look at the database starter kit first, it covers recordset creation and use in it:
database-for-php/
Once you have the recordset on the page and have it working correctly you can then move on to create the display for the items using the information coming from your db.