Main Page Categories

[marygr]

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:

[marygr]

no answer yet?? >_< :(

[satish]

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

[satish]

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

[marygr]

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