cjx Posted September 16, 2005 Share Posted September 16, 2005 Hello friends I am totally new and i am trying oscommerce offline on my computer. I already installed and its working. What i want to learn is Is it possible to choose the products that i want for the main page. Or is there any other way changing the products every refresh at the main page (random Products) Please let me know how can i do this. Thank you very much Best Regards :blush: Link to comment Share on other sites More sharing options...
cjx Posted September 16, 2005 Author Share Posted September 16, 2005 Thanks to Burt I have found how to show random products so i write here again if someone needs help So what Burt says is ; open up /includes/modules/new_products.php and change from this: $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); to this: $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 RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS); So this will make your products random at the main page Now just one more thing to learn how to choose the products we want for the main page. When i found it i will write here as well. Thank you Link to comment Share on other sites More sharing options...
lilqhgal Posted September 22, 2005 Share Posted September 22, 2005 Now just one more thing to learn how to choose the products we want for the main page. When i found it i will write here as well. I'm looking for the answer to this as well... or at least how to restrict it to one category (for frontpage items).... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.