Results 1 to 2 of 2

Random order of products in category

This is a discussion on Random order of products in category within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; At the moment, viewing products in a category displays them in alphabetical order. If there a way to make this ...

      
  1. #1
    Member
    Join Date
    Apr 2009
    Posts
    31
    Rep Power
    0


    Default Random order of products in category

    At the moment, viewing products in a category displays them in alphabetical order. If there a way to make this a random order, please?

    Many thanks.

  2. #2
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,428
    Rep Power
    48


    Default Re: Random order of products in category

    Yes.

    Add SORT BY rand() to the end of the query which is displaying the items you want to randomise.

    Regards,
    pgmarshall
    _______________________________

Similar Threads

  1. Replace New Products with Random Products on the index page
    By ridexbuilder in forum osCmax v2 Customization/Mods
    Replies: 0
    Last Post: 04-28-2009, 02:07 AM
  2. Random product from category and descendants
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 05-17-2007, 04:21 PM
  3. Changing the order of the products listed on category page
    By bigjimbo in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 05-20-2006, 03:10 AM
  4. Random order number
    By Anonymous in forum osCmax v1.7 Discussion
    Replies: 3
    Last Post: 11-09-2003, 11:21 PM
  5. Quantity to order on Special, New Products, Category ...
    By doug in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 01-02-2003, 05:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •