PHP code question
-
Hello,
Below is a PHP code for an author plugin I have on my site getyourfilmfix.com. I’m trying to change to order of the authors and any attempt simply clears the list. Currently it seems to only sort them alphabetically by display name.
Any help would be appreciated.
/** @todo Move select to get_authors().
SELECT hkwd_wp_users.ID, hkwd_wp_users.user_nicename, hkwd_wp_usermeta.user_id, hkwd_wp_usermeta.meta_value FROM hkwd_wp_users, hkwd_wp_usermeta WHERE hkwd_wp_users.ID = hkwd_wp_usermeta.user_id AND hkwd_wp_usermeta.meta_key = ‘hkwd_wp_user_level’
*/
$authors = $wpdb->get_results(“SELECT $wpdb->users.ID, $wpdb->users.user_nicename, $wpdb->usermeta.meta_value FROM $wpdb->users, $wpdb->usermeta WHERE $wpdb->users.ID = $wpdb->usermeta.user_id AND $wpdb->usermeta.meta_key = ‘”.$wpdb->prefix.”user_level’ ” . ($exclude_admin ? “AND user_login <> ‘admin’ ” : ”) . “ORDER BY display_name”);The blog I need help with is: (visible only to logged in users)
-
Your site is not hosted on WordPress.COM, this site is for support of sites hosted on WordPress.COM. You should address your questions to WordPress.ORG the keepers of the software you are using: http://wordpress.org/support/
For more on the difference: http://support.wordpress.com/com-vs-org/
- The topic ‘PHP code question’ is closed to new replies.