Código PHP:
<?php $ssql="select o.ref,o.codven,c.descri as descricate,o.nombre,o.descri,o.longdescri,o.oferta,o.precio,o.stock,img,o.codcat from objetos as o,categorias as c where o.codcat=c.codcat ";
$res=mysql_query($ssql,$cnn) or die (mysql_error());
for($cnt=0;$cnt<mysql_num_rows($res);$cnt++){
$row=mysql_fetch_assoc($res);
echo "<div align='center'>"."<table width='500'>"
."<tr bgcolor='#cccccc'>"
."<td>"."Referencia"."</td>"
."<td>"."Código vendedor"."</td>"
."<td>"."Categoria"."</td>"
."<td>"."Nombre"."</td>"
."<td>"."Descripción"."</td>"
."<td>"."Descripción larga"."</td>"
."<td>"."Oferta"."</td>"
."<td>"."Precio"."</td>"
."<td>"."Stock"."</td>"
."<td>"."img"."</td>"
."</tr>"
."<tr bgcolor='#ffff99'>"
."<td width='100'>".$row['ref']."</td>"
."<td>".$row['codven']."</td>"
."<td>".$row['descricate']."</td>"
."<td>".$row['nombre']."</td>"
."<td>".$row['descri']."</td>"
."<td>".$row['longdescri']."</td>"
."<td>".$row['oferta']."</td>"
."<td>".$row['precio']."</td>"
."<td>".$row['stock']."</td>"
."<td>".$row['img']."</td>"
."</tr>"
."</table>";
}
mysql_free_result($res);
mysql_close($cnn);
?>