List authors function mysteriously not working

im not sure why this isnt working.. but i can tell you how to get a list of the authors..

get the user ID’s of all authors (wp_user_level = 2)

$author_IDs = $wpdb->get_col("SELECT user_id FROM $wpdb->usermeta WHERE meta_key='wp_user_level' AND meta_value='2'");

get all users to compare to

$users = $wpdb->get_col("SELECT ID FROM $wpdb->users");

compare

for($j=0; $j < count($author_IDs); $j++){
    if(in_array($author_IDs,$users){
      echo $author_IDs[$j];
    }
  }

not the most elegant coding.. but hey 😛

i havent seen it mentioned as an issue with 3.1 although i dont suppose people use that function much..

it appears to still be on the 3.1 function list so it hasnt been depreciated.. in fact they added functionality to it by allowing orderby and number

http://codex.wordpress.org/Function_Reference/wp_list_authors

ok if ever you are getting a blank page like that it means there is a php error.. so i may have typed something wrong if you jsut copy pasted..

to check if thats the case.. pop

error_reporting(E_ALL);
ini_set('display_errors', '1');

at the top of the archive page and it should tell you if you have made a call to an unknown function or something..

i can actually see where i have gone wrong.. let me ammend my code and ill comment where to add list items around the names the section you want to edit is in the comparison loop:

$author_IDs = $wpdb->get_col("SELECT user_id FROM $wpdb->usermeta WHERE meta_key='wp_user_level' AND meta_value='2'");
$users = $wpdb->get_results("SELECT ID, user_login FROM $wpdb->users");
for($j=0; $j < count($users); $j++){
    if(in_array($users[$j][ID],$author_IDs){
      //things before the username
      echo $users[$j][user_login];
      //things after the username
    }
  }

now if you wanted them to be list items youd want to replace my comments with

echo "<li>";

and

echo "</li>";

respectfully

sorry for the mess up

i also forgot that you were going to want the users username not just their ID..

oh WOW im silly

im sorry… here this IS THE CORRECT CODE!! (i not only forgot my closing bracket i also forgot that multi dimentional arrays dont get accessed like that in PHP )

$author_IDs = $wpdb->get_col("SELECT user_id FROM $wpdb->usermeta WHERE meta_key='wp_user_level' AND meta_value='2'");
$users = $wpdb->get_results("SELECT ID, user_login FROM $wpdb->users"); ?>
<ul>
<?php
for($j=0; $j < count($users); $j++){
    if(in_array($users[$j]->ID,$author_IDs0){
      //things before the username
      echo "<li>".$users[$j]->user_login."</li>";
      //things after the username
    }
  }
?>
</ul>

as a sorry again i put it in a list for you…

my bad

yes.. its 1am in Australia.. im sorry

oh for the love of god.. i typed a 0 instead of a close bracket…

<?php
$author_IDs = $wpdb->get_col("SELECT user_id FROM $wpdb->usermeta WHERE meta_key='wp_user_level' AND meta_value='2'");
$users = $wpdb->get_results("SELECT ID, user_login FROM $wpdb->users"); ?>
<ul>
<?php
for($j=0; $j < count($users); $j++){
    if(in_array($users[$j]->ID,$author_IDs)){
      //things before the username
      echo "<li>".$users[$j]->user_login."</li>";
      //things after the username
    }
  }
?>
</ul>

i have tested this on my own server and it works ok for me 🙁

oh and delete that error checking thing from the top of the page now too…

are the people that you say are ‘authors’ actually set to be ‘Author’ in their user role?

by this i mean.. under your users section of the dashboard.. click ‘edit’ on any of the users you want to show and check that their role is set to Author..

if you want a list of people from a different role let me know and ill make the changes