marygr Posted August 21, 2005 Share Posted August 21, 2005 Hello! I want to change the categories in the first page, Now at the center of the page is the New products, this I want to change I want of the Best View products of products of my choice. Can somebody help me? I am new at PHP and it's difficult for me to make the changes myself... :rolleyes: :rolleyes: :rolleyes: Thank you! PS. Also I would like to know how can i erase the prices. I have a shop and we don't want to put prices, now it's zero all the prices but i think it's better if that choice will be out.. :blush: Link to comment Share on other sites More sharing options...
marygr Posted August 22, 2005 Author Share Posted August 22, 2005 no answer yet?? >_< :( Link to comment Share on other sites More sharing options...
satish Posted August 22, 2005 Share Posted August 22, 2005 no answer yet?? >_< :( <{POST_SNAPBACK}> Just go to the Db and change the number of times the product has been viewed and let the product you want to display have the max count. In this solution no need to do any coding Satish Mantri Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
satish Posted August 22, 2005 Share Posted August 22, 2005 Hello! I want to change the categories in the first page, Now at the center of the page is the New products, this I want to change I want of the Best View products of products of my choice. Can somebody help me? I am new at PHP and it's difficult for me to make the changes myself... :rolleyes: :rolleyes: :rolleyes: Thank you! PS. Also I would like to know how can i erase the prices. I have a shop and we don't want to put prices, now it's zero all the prices but i think it's better if that choice will be out.. :blush: <{POST_SNAPBACK}> Here is the code solution you have in boxes/best_sellers.php folowing lines on line 14 $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name 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 = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS replace with $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = your product id ); Satish Mantri Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
marygr Posted August 22, 2005 Author Share Posted August 22, 2005 Here is the code solution you have in boxes/best_sellers.php folowing lines on line 14 $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name 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 = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS replace with $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = your product id ); Satish Mantri <{POST_SNAPBACK}> thank you!! thank you!! thank you!! :D Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.