Saludos, ahi va..
<?php
$link = mysql_connect("localhost", "Usuario_DB", "Pass_DB");
mysql_select_db("DATABASE", $link);
$result = mysql_query("SELECT t1.product_id, t1.image, t2.product_id, t2.name, t2.description
FROM oc_product AS t1, oc_product_description AS t2
WHERE t1.product_id = t2.product_id", $link);
while ($row = mysql_fetch_array($result)){
echo "<ul> \n";
do {
echo "<li> \n";
echo "<p class='img'><img class='imgj' src='http://tecnisistemascr.com/store/image/".$row["image"]."' alt='picture' width='250' height='150' /></p> \n";
echo "<h2>".$row["name"]." <span class='blue'></span></h2> \n";
echo "<p>".html_entity_decode($row["description"])."</p> \n";
echo "<p><a href='index.php'><img src='images/prev.gif' alt='picture' width='69' height='23' border='0' /></a> <a href='index.php'><img src='images/next.gif' alt='picture' width='69' height='23' border='0' /></a></p> \n";
echo "</li> \n";
}
echo "</ul> \n";
else
{
echo "¡ La base de datos está vacia !";
}
?>