Guest Posted January 27, 2007 Posted January 27, 2007 Hi! A have problem with the taxes. In "new_products.php" the price is shown without the taxes on 25%, but when i go to "product_info.php" the price is ok. Have sombody a solutions to this problem? www.minidata.no The code in new_products.php is: <?php /* $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ ?> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=290,height=290,screenX=290,screenY=290,top=150,le ft=150'); } //--></script> <!-- new_products //--> <?php $info_box_contents = sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')); if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select 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 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; ?> <table border="0" cellspacing="0" cellpadding="0"> <tr><td height="29"></td></tr> <tr><td class="tx2"> <?=HEADING_TITLE?> </td></tr> <tr><td height="10"></td></tr> <tr><td width="477" height="1" bgcolor="#959595"></td></tr> <tr><td height="8"></td></tr> </table> <table border="0" cellspacing="0" cellpadding="0"> <? 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)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $new_products['products_description'] = $product['products_description']; if (($col==0) && ($row!=0)) echo '</td></tr> <tr><td height="9" colspan="3"></td></tr>'; if ($col==0) echo '<tr><td width="235" valign="top">'; ?> <table border="0" cellspacing="0" cellpadding="0"> <tr><td class="bd" width="235"> <table border="0" cellspacing="0" cellpadding="0" width="233"> <tr><td height="7" colspan="3"></td></tr> <tr><td width="115" align="center" valign="top"><a href="<?=tep_href_link('product_info.php?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)?></a></td> <td width="110" valign="middle"><br style="line-height:1px;"><br style="line-height:10px;"><a class="ml1" href="<?=tep_href_link('product_info.php?products_id='.$new_products['products_id'])?>"><?=$new_products['products_name']?></a><br style="line-height:1px;"><br style="line-height:10px;"></td> <td width="10"></td></tr> <tr><td height="9" colspan="3"></td></tr> </table> </td></tr> <tr><td height="32" align="right" style="padding-right:37px;"><span class="tx3"><?=$currencies->display_price($new_products['products_price'],'')?></span></td></tr> <tr><td><a href="<?=tep_href_link('product_info.php?products_id='.$new_products['products_id'])?>"><?=tep_image_button("button_details.gif");?></a><a href="<?= tep_href_link("products_new.php","action=buy_now&products_id=".$new_products['products_id'])?>"><?=tep_image_button("button_add_to_cart.gif");?></a></td></tr> </table> <? if ($col==1) { echo ''; $row++; $col=0; } else { echo ' </td> <td width="7"></td> <td width="235" valign="top">'; $col++; } } if ($col==1) echo '</td></tr>' ?> </table>
Guest Posted January 27, 2007 Posted January 27, 2007 Use the Nintendo Wii product to the site to see the problem!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.