As Longshanks said above, you need to query the Db. This would be something along these lines:

SELECT ProductId, ProductName, ProductDescription
FROM Products

Use PHP to execute the query and you get a recordset, that is actually very much like the DB table, but only with the columns (ProductId, ProductName, ProductDescription) you specified in the SELECT clause.

When you have the records set, you loop through it. Sortof like this (i don't know PHP too well, so it will be pseudo code):

string query = "SELECT ProductId... " // see the query above
Recordset products = database.Execute(query)

write ("<table>")
foreach (product in products)
{

write ("<tr>")
write ("<td>" + product.ProductId + "</td>")
write ("<td>" + product.ProductName + "</td>")
write ("<td>" + product.ProductDescription + "</td>")
write ("</tr>")
}
write ("</table>")

This will display a html table with all the products in it. Change thje query (dynamically through PHP) to change what is displayed.

You probably know most of this, but I just wanted to give a comprihensive example (i hope).

Show me the you code, and I will be more specific ;-)

Hope this helps.

Kind regards
AllYourBase AreBelongToUs / Borne OfFire

------------
Dude: "My thief BS for 800 dmg! Omfg, omfg, lawl, noobzorz"
AYB (drunk): "Do people take damage from being bullshitted? WTF???"