Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some investigation and get back to you if I find an answer. You should email the people at iPage as they probably can answer it..

Change the sort order by from rand to something else such as product_id.

Is this featured products 1.5.

If it is my recent release Wolfen Featured Sets then you can control this from admin.

This post has been edited by.

241.

: 22 July 2004, 21:38..

Thx for quick replies. well the featured limit I have is set to 20 , and total products I added are 16 but products still switch their location..

This is the code I have not sure what to change.

<! featured_products //>.

<?php.

If(FEATURED_PRODUCTS_DISPLAY == 'true').

{.

 $featured_products_category_id = $new_products_category_id;.

 $cat_name_query = tep_db_query("select categories_name from categories_description where categories_id = '"$featured_products_category_id"' limit 1");.

 $cat_name_fetch = tep_db_fetch_array($cat_name_query);.

 $cat_name = $cat_name_fetch['categories_name'];.

 $info_box_contents = array();.

 if ( (!isset($featured_products_category_id)) || ($featured_products_category_id == '0') ) {.

   $info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="'tep_href_link(FILENAME_FEATURED_PRODUCTS)'">'TABLE_HEADING_FEATURED_PRODUCTS'</a>');.

 list($usec, $sec) = explode(' ', microtime());.

 srand( (float) $sec + ((float) $usec * 100000) );.

 $mtm= rand();.

   $featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id left join "TABLE_FEATURED" f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand($mtm) DESC limit "MAX_DISPLAY_FEATURED_PRODUCTS);.

 } else {.

   $info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name));.

   $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id, "TABLE_PRODUCTS_TO_CATEGORIES" p2c, "TABLE_CATEGORIES" c left join "TABLE_FEATURED" f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '"$featured_products_category_id"' and p.products_status = '1' and f.status = '1' order by rand() DESC limit "MAX_DISPLAY_FEATURED_PRODUCTS);.

 }.

 $row = 0;.

 $col = 0;.

 $num = 0;.

 while ($featured_products = tep_db_fetch_array($featured_products_query)) {.

   $num ++; if ($num == 1) { new contentBoxHeading($info_box_contents); }.

   $featured_products['products_name'] = tep_get_products_name($featured_products['products_id']);.

   if($featured_products['specstat']) {.

     $info_box_contents[$row][$col] = array('align' => 'center',.

                                          'params' => 'class="smallText" width="33%" valign="top"',.

                                          'text' => '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$featured_products['products_id'])'">'tep_image(DIR_WS_IMAGES$featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a><br><a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$featured_products['products_id'])'">'$featured_products['products_name']'</a><br><s>'$currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id']))'</s><br><span class="productSpecialPrice">'.

                                          $currencies->display_price($featured_products['specials_new_products_price'], tep_get_tax_rate($featured_products['products_tax_class_id']))'</span>');.

   } else {.

     $info_box_contents[$row][$col] = array('align' => 'center',.

                                          'params' => 'class="smallText" width="33%" valign="top"',.

                                          'text' => '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$featured_products['products_id'])'">'tep_image(DIR_WS_IMAGES$featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a><br><a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$featured_products['products_id'])'">'$featured_products['products_name']'</a><br>'$currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])));.

   }    .

   $col ++;.

   if ($col > 2) {.

     $col = 0;.

     $row ++;.

   }.

 }.

 if($num) {.

     .

     new contentBox($info_box_contents);.

 }.

} else // If it's disabled, then include the original New Products box.

{.

  include (DIR_WS_MODULESFILENAME_NEW_PRODUCTS);.

}.

?>.

<! featured_products_eof //>..

Yep order by rand is shown.

Order by rand()..

This is the version I am using.

Featured Products V1.1.

Displays a list of featured products, selected from admin.

For use as an Infobox instead of the "New Products" Infobox..

Steve what do I change that to so they dont move..

Change to something like.

Order by p.products_id.

This fixes the featured products to the max number chosen and displays them in order of product_id you can also use other things from the query...

Steve I have no knowledge of this.

Can ya please explain in details this is what I have done and it's not working.

<?php.

/*.

 osCommerce, Open Source E-Commerce Solutions.

 http://www.oscommerce.com.

 Copyright (c) 2002 osCommerce.

 Released under the GNU General Public License.

 .

 Featured Products V1.1.

 Displays a list of featured products, selected from admin.

 For use as an Infobox instead of the "New Products" Infobox  .

*/.

?>.

<! featured_products //>.

<?php.

If(FEATURED_PRODUCTS_DISPLAY == 'true').

{.

 $featured_products_category_id = $new_products_category_id;.

 $cat_name_query = tep_db_query("select categories_name from categories_description where categories_id = '"$featured_products_category_id"' limit 1");.

 $cat_name_fetch = tep_db_fetch_array($cat_name_query);.

 $cat_name = $cat_name_fetch['categories_name'];.

 $info_box_contents = array();.

 if ( (!isset($featured_products_category_id)) || ($featured_products_category_id == '0') ) {.

   $info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="'tep_href_link(FILENAME_FEATURED_PRODUCTS)'">'TABLE_HEADING_FEATURED_PRODUCTS'</a>');.

 list($usec, $sec) = explode(' ', microtime());.

 srand( (float) $sec + ((float) $usec * 100000) );.

 $mtm= p.products_id();.

   $featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id left join "TABLE_FEATURED" f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by p.products_id($mtm) DESC limit "MAX_DISPLAY_FEATURED_PRODUCTS);.

 } else {.

   $info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name));.

   $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id, "TABLE_PRODUCTS_TO_CATEGORIES" p2c, "TABLE_CATEGORIES" c left join "TABLE_FEATURED" f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '"$featured_products_category_id"' and p.products_status = '1' and f.status = '1' order by p.products_id() DESC limit "MAX_DISPLAY_FEATURED_PRODUCTS);.

 }.

 $row = 0;.

 $col = 0;.

 $num = 0;.

 while ($featured_products = tep_db_fetch_array($featured_products_query)) {.

   $num ++; if ($num == 1) { new contentBoxHeading($info_box_contents); }.

   $featured_products['products_name'] = tep_get_products_name($featured_products['products_id']);.

   if($featured_products['specstat']) {.

     $info_box_contents[$row][$col] = array('align' => 'center',.

                                          'params' => 'class="smallText" width="33%" valign="top"',.

                                          'text' => '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$featured_products['products_id'])'">'tep_image(DIR_WS_IMAGES$featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a><br><a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$featured_products['products_id'])'">'$featured_products['products_name']'</a><br><s>'$currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id']))'</s><br><span class="productSpecialPrice">'.

                                          $currencies->display_price($featured_products['specials_new_products_price'], tep_get_tax_rate($featured_products['products_tax_class_id']))'</span>');.

   } else {.

     $info_box_contents[$row][$col] = array('align' => 'center',.

                                          'params' => 'class="smallText" width="33%" valign="top"',.

                                          'text' => '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$featured_products['products_id'])'">'tep_image(DIR_WS_IMAGES$featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a><br><a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$featured_products['products_id'])'">'$featured_products['products_name']'</a><br>'$currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])));.

   }    .

   $col ++;.

   if ($col > 2) {.

     $col = 0;.

     $row ++;.

   }.

 }.

 if($num) {.

     .

     new contentBox($info_box_contents);.

 }.

} else // If it's disabled, then include the original New Products box.

{.

  include (DIR_WS_MODULESFILENAME_NEW_PRODUCTS);.

}.

?>.

<! featured_products_eof //>..

Change:.

Change both to ORDER BY p.products_id ASC - for ascending order. Drop the ($mtm)..

You can use desc or asc but yes drop the ($mtm) not required and in the second remove the () from after products_id as not required either..

Never doubted it for a moment, glad all worked out for you..

Hello guys I have installed the featured products contribution but what I want is that the product wont change their location right now every time I refresh it rotates..

Any help is greatly apprecaited.

Thankyou..

Nevermind, I think you mean that you don't want the ones that are shown to move around randomly..

Original Post:.

In the contribution, there should be something to indicate how many you want to display - change that to how many you want to feature. If you go above that amount, it will rotate (there aren't enough slots)..

This post has been edited by.

Kepa.

: 22 July 2004, 21:37..