I installed a Wordpress plugin to display registered users and need it to sort by last name.
Here is the query I think needs to be changed.
Code:
$query = "SELECT ID, user_nicename FROM $wpdb->users WHERE ID = ANY (SELECT user_id FROM $wpdb->usermeta WHERE meta_value IN ($roles)) ORDER BY user_nicename LIMIT $offset, $usersPerPage";
The plugin author suggested this, but it did not work.
Code:
$query = "SELECT ID, user_nicename FROM $wpdb->users WHERE ID = ANY (SELECT user_id FROM $wpdb->usermeta WHERE meta_value IN ($roles)) ORDER BY $wpdb->usermeta.last_name LIMIT $offset, $usersPerPage";
I'm not familiar with wordpress but the following should work.
PHP Code:
$query = "SELECT ID, user_nicename FROM $wpdb->users WHERE ID = ANY (SELECT user_id FROM $wpdb->usermeta WHERE meta_value IN ($roles)) ORDER BY last_name LIMIT $offset, $usersPerPage";
Yeah, that doesn't work. When I use that no users are displayed.
I've done a lot of searching the last couple of days, I'm not so sure it's possible.
if you have any ideas I'm all ears.