Title: Randomize
Last modified: August 22, 2016

---

# Randomize

 *  [Tiago1981](https://wordpress.org/support/users/tiago1981/)
 * (@tiago1981)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/randomize-2/)
 * I can’t use randomize. If i choose this option there will be no reviews visible
 * [https://wordpress.org/plugins/rich-reviews/](https://wordpress.org/plugins/rich-reviews/)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Contributor [Nuanced Media](https://wordpress.org/support/users/nuanced-media/)
 * (@nuanced-media)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/randomize-2/#post-5203175)
 * Hey Tiago1981,
 * We will check our sql queries to confirm functionality. If we can replicate the
   issue then we will find a solution and release an update.
 *  Thread Starter [Tiago1981](https://wordpress.org/support/users/tiago1981/)
 * (@tiago1981)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/randomize-2/#post-5203200)
 * I have the latest update but there is nothing changed
 *  [Leppink](https://wordpress.org/support/users/leppink/)
 * (@leppink)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/randomize-2/#post-5203201)
 * Managed to fix this issue.
 * replace the following:
 *     ```
       function order_by($key, $sort = 'ASC') {
               $this->order_by = ' ORDER BY <code>' . $key . '</code> ' . $sort;
           }
       ```
   
 * with
 *     ```
       function order_by($key, $sort = 'ASC') {
               $this->order_by = ' ORDER BY ' . $key . ' ' . $sort;
           }
       ```
   
 * in
 * wp-content/plugins/rich-reviews/lib/nmdb.php
 *  [DNR Groups](https://wordpress.org/support/users/deepak_gupta/)
 * (@deepak_gupta)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/randomize-2/#post-5203205)
 * EDIT THIS FILE ON LINE NUMBER( wp-content/plugins/rich-reviews.php LINE NUMBER:-
   > 446 )
 * ( Replace this code to the new one )
    OLD=>
 *     ```
       $this->db->order_by('rand()');
       ```
   
 * NEW=>
 *     ```
             $order_query = "ORDER BY rand()";
             $this->db->$order_query;
       ```
   
 * Thank to yesmeen

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Randomize’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/rich-reviews_e3f9fb.svg)
 * [Rich Reviews by Starfish](https://wordpress.org/plugins/rich-reviews/)
 * [Support Threads](https://wordpress.org/support/plugin/rich-reviews/)
 * [Active Topics](https://wordpress.org/support/plugin/rich-reviews/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/rich-reviews/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/rich-reviews/reviews/)

 * 4 replies
 * 4 participants
 * Last reply from: [DNR Groups](https://wordpress.org/support/users/deepak_gupta/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/randomize-2/#post-5203205)
 * Status: not resolved