Sql query to get all users

  • nonname

    (@bipies)


    14 years, 9 months ago

    Hi:

    I’m using this sql query to get all users:

    $excluded = '1,29,24';
$sql = 'SELECT distinct post_author FROM '.$wpdb->posts. " WHERE post_author NOT IN ($excluded) ORDER BY rand()";
$authors = $wpdb->get_results($sql)

    ;

    But whe executed always appear a repeated user with wrong “latest post” and don’t know why, any idea?

    Thanks!

The topic ‘Sql query to get all users’ is closed to new replies.