user meta and a user page loop

Here is my next run at the wall… I was PHP coding about five years ago, and this code syntax may show it.

https://pastebin.com/FNCekLf6

I was able to return data from the db wp_users table, and populate the HTML fields below, but the structure of the db wp_usermeta table is weird. So the table JOIN breaks at the following line.
while ($usersarray = mysql_fetch_array($usersselect)) {

any help would go a long way.

If I understood you correctly you wanted a list of all the authors and editors, in which case you were looking at the wrong function.

I think get_users is what you were looking for:

<?php
if ($editors = get_users( 'orderby=nicename&role=editor' )) {
    echo '<h4>Editors</h4>';
    echo '<ul>';
    foreach ($editors as $user) {
        echo '<li>' . $user->user_nicename . '</li>';
    }
    echo '</ul>';
}

if ($authors = get_users( 'orderby=nicename&role=author' )) {
    echo '<h4>Authors</h4>';
    echo '<ul>';
    foreach ($authors as $user) {
        echo '<li>' . $user->user_nicename . '</li>';
    }
    echo '</ul>';
}
?>

the CODEX says that get_user function is depreciated.

This code works, it runs a loop and delivers all users only once in teh return. https://pastebin.com/LwNw1CPs

But it only returns half of the info (from the wp_users table); when I try to JOIN the wp_usermeta table it fails.

Also, if anyone could stear me in the right direction so I can make good WP DB query requests I would appreciate it.

get_users (available since 3.1):
https://codex.www.ads-software.com/Function_Reference/get_users

wow… I don’t know what I was looking at earlier.

the CODEX says that get_user function is depreciated.

i am goping with “lack of sleep” as an excuse. Thanks I will take tray again.

Thanks for your response Andrei.
Okay that helped in a big way. That resolved my SORT and EXCLUDE issues. The only hurdle now is: getting the meta_values and the meta_keys using the get_users function. The SYNTAX on that part eludes me.
https://pastebin.com/7MnmH2U4

The CODEX looks light in that regard. Trying to ask the right question in the search field.

You need to add fields parameter.

$blogusers = get_users(array(
    'blog_id' => 1,
    'orderby' => 'blog_id',
    'exclude' => 1,
    'fields'  => 'all_with_meta'
));

And then inside foreach add (to add the avatar)

$user_avatar = get_avatar($user->ID, 32);
echo '<a href="' . $user->user_url . '" target="_blank">' . $user_avatar . '</a>';

the rest will work as it is now.

CheckMate!!! Andrei you are the smartest Norwegian I know.
Your guidance and help is very much appreciated.
https://www.chessgames.com/perl/chessgame?gid=1243022

Hehe! Nice game ?? and no problem, really.