drmilos Posted March 29, 2014 Share Posted March 29, 2014 Hi all, I got a problem with product shown on the top left corner of the site. There is three products on my site and that content box show all three products. Since I added fourth product, newly listed product it is on position 3 and product that was been on that position now missing. How can I show more than three products in that area Quote Link to comment Share on other sites More sharing options...
drmilos Posted March 29, 2014 Author Share Posted March 29, 2014 Hi all, I got a problem with product shown on the top left corner of the site. There is three products on my site and that content box show all three products. Since I added fourth product, newly listed product it is on position 3 and product that was been on that position now missing. How can I show more than three products in that area Here is the answer, It is class ui-widget infoBoxContainer a You need to edit header.php from /include directory. Then find: $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, 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_DESCRIPTION . " pd, " . 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' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by pd.products_name asc limit " . 3); and change to: $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, 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_DESCRIPTION . " pd, " . 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' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by pd.products_name asc limit " . 4); Then all four products are listed. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.