Post Author alphabetical order

So in Write->Post you want the Post author list to be in a different order?

If so, in 2.0.1 you can change the function get_editable_authors() in wp-admin/admin-db.php at around line 37 to return the author in a different order.

Change this:
$authors = $wpdb->get_results( "SELECT * FROM $wpdb->users WHERE ID IN ($editable)" );

to:

$authors = $wpdb->get_results( "SELECT * FROM $wpdb->users WHERE ID IN ($editable) ORDER BY display_name" );

You could change display_name to user_nicename or any other field in the wp_users table.

Several warnings though–changing core programs in not recommended as you will be responsible in the future to ‘retrofit’ this change into new versions. Also make a copy of wp-admin/admin-db.php before attempting this.

Thank you for your quick response and assistance in resolving this. I have made a backup copy before making the change.

Can anyone answer why this isn’t setup like this as a default? It makes no sense to have the authors listed in order they were added into the user table. My site has over 100 users in it though so I may be an exception.

Is there somewhere where this might be suggested as a default for future versions?

The [email protected] listserv maybe….

Or you can put in a ticket at https://trac.www.ads-software.com

You can use your forum login and password there…

Ohhh thank you for this thread. I too have been wondering why authors aren’t alphabetically arranged. Very odd. I’m really glad there’s a fix. Thanks MichaelH, and kahleeb for asking in the first place. =)