isimpledesign Posted November 12, 2010 Share Posted November 12, 2010 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 More sharing options...
ManiacDan Posted November 12, 2010 Share Posted November 12, 2010 GROUP BY um.user_id) ORDER BY RAND() -Dan Link to comment https://forums.phpfreaks.com/topic/218478-rand-order/#findComment-1133428 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.