Jump to content

Rand Order


isimpledesign

Recommended Posts

Really need a hand from someone mysql query is pretty basic.

 

I have been ask to add a random order to this query.

 

 $query = "SELECT rd.user_id
            FROM {$regions_data_table} rd
            WHERE rd.field_id = {$regions_field_id} AND rd.value LIKE %s
                  AND rd.user_id NOT IN (SELECT um.user_id
                                         FROM {$wpdb->base_prefix}usermeta um
                                         WHERE ((um.meta_key='wp_ul_disabled' AND um.meta_value=1) OR (um.meta_key='wp_ul_inactive' AND um.meta_value=1))
                                         GROUP BY um.user_id)";

 

I have tried so many options but cannot seem to get it to work i am trying to insert order by rand().

 

Any help please?

Link to comment
https://forums.phpfreaks.com/topic/218478-rand-order/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.