File: /home/nexper/public_html/php/modules/ofertas.php
<?php
$query = "SELECT * FROM productos WHERE prod_oferta = '1' ORDER BY RAND() LIMIT 20";
$result = mysql_query($query);
echo '<table width="700" align="center" border="0" cellspacing="0" cellpadding="0" id="contenido">'.
'<tr>'.
'<td colspan="'.$cols.'" align="left" class="title" valign="top" height="25">OFERTAS</td>'.
'</tr>'.
'<tr>'.
'<td colspan="'.$cols.'" align="center">';
while ($cant = mysql_fetch_assoc($result)) {
$nom_url = $cant{'prod_nom'};
$image_c = get1img($cant{'prod_id'}, 80, 80);
if ($cant{'prod_venta'} == 0 || empty($cant{'prod_venta'})) {
$precio = "";
} else {
$precio = "<b>a solo $ ".number_format($cant{'prod_venta'}, 0, ',', '.')."</b>";
}
if ($cant{'prod_stock'} == 1)
$stock = "<div class='green' style='font-size:12px'>En Stock</div>";
else
$stock = "<div class='red' style='font-size:12px'>No Disponible</div>";
if ($cant{'prod_pedido'} == 1)
$pedido = "<div style='font-size:9px'>Producto sólo a pedido</div>";
else
$pedido = "";
// echo '<td class="'.$colors[$i].'" onmouseover=this.className="rowover" onmouseout=this.className="'.$colors[$i].'" align="center" width="175" valign="middle">'.
echo '<div style="position:relative; display:inline-block; width:175px; height:200px; background:url(images/item_bg.png); text-align:center;">'.
'<div style="position:absolute; top:2px; width:170px; height:20px; text-align:center;"><a href="?sec=3&idp='.$cant{'prod_id'}.'" target="_self">'.item_name($nom_url).'</a></div>'.
'<div style="position:absolute; top:42px; width:170px; height:80px; text-align:center;"><a href="?sec=3&idp='.$cant{'prod_id'}.'" target="_self">'.$image_c.'</a></div>'.
'<div style="position:absolute; top:149px; width:170px; height:20px; text-align:center;">'.$precio."</div>".
'<div style="position:absolute; top:166px; width:170px; height:20px; text-align:center;">'.$stock."</div>".
'<div style="position:absolute; top:183px; width:170px; height:20px; text-align:center;">'.$pedido."</div>".
'</div>';
}
echo '</td></tr>'.
'</table>';
mysql_close ($conex);
?>