3afooor Posted January 28, 2004 Share Posted January 28, 2004 hi all how can i remove the best sellers numbers ex: 1- 2- 3- 4- ----------------------------------------------- <?php /* $Id: best_sellers.php,v 1.19 2002/06/05 20:59:08 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2001 osCommerce Released under the GNU General Public License */ ?> <!-- best_sellers //--> <?php if ($cPath) { $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_ordered from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (c.categories_id = '" . $current_category_id . "' OR c.parent_id = '" . $current_category_id . "') order by p.products_ordered DESC, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS); } else { $best_sellers_query = tep_db_query("select p.products_id, pd.products_name, p.products_ordered from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by p.products_ordered DESC, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS); } if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) { ?> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('align' => 'center', 'text' => BOX_HEADING_BESTSELLERS ); new infoBoxHeading($info_box_contents, false, false); $rows = 0; $info_box_contents = array(); while ($best_sellers = tep_db_fetch_array($best_sellers_query)) { $rows++; $info_box_contents[] = array('align' => 'center', 'text' => tep_row_number_format($rows) . '. <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id'], 'NONSSL') . '">' . $best_sellers['products_name'] . '</a>'); } new infoBox5($info_box_contents); ?> </td> </tr> <?php } ?> <!-- best_sellers_eof //--> this is the code can any one modify it for me plz Link to comment Share on other sites More sharing options...
mtimdog Posted January 28, 2004 Share Posted January 28, 2004 It looks like you would take out tep_row_number_format($rows) and the space Link to comment Share on other sites More sharing options...
3afooor Posted January 28, 2004 Author Share Posted January 28, 2004 plz can u cut and paste the modified code for me because it also not work when i modify it plz Link to comment Share on other sites More sharing options...
Noobish-n-stuff Posted January 28, 2004 Share Posted January 28, 2004 try this: <?php /* $Id: best_sellers.php,v 1.19 2002/06/05 20:59:08 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2001 osCommerce Released under the GNU General Public License */ ?> <!-- best_sellers //--> <?php if ($cPath) { $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_ordered from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (c.categories_id = '" . $current_category_id . "' OR c.parent_id = '" . $current_category_id . "') order by p.products_ordered DESC, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS); } else { $best_sellers_query = tep_db_query("select p.products_id, pd.products_name, p.products_ordered from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by p.products_ordered DESC, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS); } if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) { ?> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('align' => 'center', 'text' => BOX_HEADING_BESTSELLERS ); new infoBoxHeading($info_box_contents, false, false); $rows = 0; $info_box_contents = array(); while ($best_sellers = tep_db_fetch_array($best_sellers_query)) { $rows++; $info_box_contents[] = array('align' => 'center', 'text' => '. <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id'], 'NONSSL') . '">' . $best_sellers['products_name'] . '</a>'); } new infoBox5($info_box_contents); ?> </td> </tr> <?php } ?> <!-- best_sellers_eof //--> that should do it... Link to comment Share on other sites More sharing options...
mtimdog Posted January 28, 2004 Share Posted January 28, 2004 the above code still puts the space in btw. Link to comment Share on other sites More sharing options...
3afooor Posted January 28, 2004 Author Share Posted January 28, 2004 thanks alot its ok now :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.