$sql = mysql_query("select products.id,products.name,
products.descrip,
products.price,category.id,category.name
from spec,products,category
where products.id = spec.prodid
and products.catid = category.id
and spec.spec = 'yes'");
while($row = mysql_fetch_array($sql))
{
$img = $row[0].".jpg";
$name = $row[1];
$desc = $row[2];
$price = $row[3];
$catid = $row[4];
$catname = $row[5];
echo "

";
echo $name."
".$desc."
".$price."
View All Products from this Category";
}
?>