Dios, quiero llorar
.................
He conseguido poner bien esa maldita línea, pero ahora resulta que no hace lo que yo quiero. Yo quiero que cuando un artículo de mi tienda esté marcado con
peso=0, aparezca la imagen "
frete_gratis.gif", si el peso no es =0 no debe aparecer esa imagen, sin embargo tal y como ha quedado la imagen aparece siempre en todos los artículos. Yo creí que esto era fácil, que esa línea me bastaría, xD.
El archivo completo no es muy largo, seguido lo pego completo a ver si alguien me ilumina; se que aquí hay gente muy buena en este tema.
Archivo completo, abro espacios entre la línea en cuestión para identificarla:
Código PHP:
<!-- new_products //-->
<?php
if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
$new_products_query = tep_db_query("select p.products_id, p.products_weight, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
} else {
$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
}
$row = 0;
$col = 0;
echo '
<table cellspacing=0 cellpadding=0 width=437 align=center>
<tr><td background=images/m22.gif width=437 height=29 valign=top>
<table cellspacing=0 cellpadding=0>
<tr><td height=8></td></tr>
<tr><td width=25></td><td class=ch6>Productos Destacados</td></tr>
</table>
</td></tr>
<tr><td valign=top class=ch7>
<table cellspacing=0 cellpadding=0 width=417 border=0 align=center>
<tr><td height=13></td></tr>
<tr>
';
while ($new_products = tep_db_fetch_array($new_products_query)) {
$new_products['products_name'] = tep_get_products_name($new_products['products_id']);
$product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$new_products['products_id'] . "' and language_id = '" . (int)3 . "'");
$product = tep_db_fetch_array($product_query);
$new_products['products_description'] = $product['products_description'];
echo '
<td width=208 valign=top align=center>
<table cellspacing=0 cellpadding=0 width=200 align=center>
<tr><td width=90 align=center valign=top><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'vspace=0') . '</a></td>
<td valign=top>
<table cellspacing=0 cellpadding=0>
<tr><td><a height=35 valign=middle class=ch9 href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a></td></tr>
<tr><td class=ch10 height=35 valign=middle>'.preg_replace('/\s\S*$/i', '', substr($new_products['products_description'], 0, 25)).' ...</td></tr>
<tr><td height=0></td></tr>
<tr><td><span class=ch11>precio:</span> <span class=ch8>'.$currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).'</span> </td></tr>
</table>
</td>
</tr>
<tr><td height=20></td></tr>
<tr><td colspan=2 align=left><a href="' . (tep_draw_hidden_field('products_id=' . $new_products['products_id']) . $new_products['products_weight'] == 0) . '">' . tep_image_submit('frete_gratis.gif', frete_gratis) . '</a>
<tr><td colspan=2 align=right><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image_button('detalles.gif') . '</a> <br></td></tr>
<tr><td colspan=2 align=right><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']) . '">' . tep_image_button('carrito.gif') . '</a>
</table>
</td>
';
$col ++;
if ($col > 1) {
$col = 0;
$row ++;
echo '
</tr>
<tr><td height=5></td></tr>
<tr><td colspan=3 valign=top>
<table cellspacing=0 cellpadding=0>
<tr><td width=200 height=1 background=images/m29.gif></td><td width=14></td> <td width=200 height=1 background=images/m29.gif></td></tr>
</table>
</td></tr>
<tr><td height=5></td></tr>
<tr>
';
} else echo '<td background=images/m09.gif width=1></td>';
}
echo '
</tr>
</table>
</td></tr>
<tr><td><img src=images/m30.gif width=438 height=7></td></tr>
</table>
';
?>
<!-- new_products_eof //-->
Gracias a todos por vuestra ayuda.