Wordpress/PHP/MySql sort results

Question

I have a query that loads values from the database based upon a province a user lives:

$query = "SELECT * FROM $wpdb->usermeta WHERE meta_key='provincie' AND ( ".$provincie_check.")";

This loads all provinces that a user holds. Based upon this I load the users:

for($p=0; $p <count($personen); $p++){
    $persoon = $personen[$p];
    if ($p % 2 == 0){
            $oddeven = 'even';
        }else{
            $oddeven = 'odd';
        }
        $id = $persoon->user_id;
        $user_info = get_userdata($id);
        $p_fname = get_user_meta($id, 'first_name', true); 
        $p_fname = array($p_fname);
        sort($p_fname);
}

For every user I create a table to view them. I want them sorted upon ther first name. So I thought I create an array of all first names and sort that. But no luck.

How can I sort the for-loop to view my users sorted by their first name?

This should be throwing an error AND ( ".$provincie_check."). Unless you've got something for it that will valid syntax. — Funk Forty Niner
– Funk Forty Niner, Commented Apr 9, 2015 at 13:51
Nope no error you just missed a part of the code that provides $province_check it results 'meta_value' LIKE '%province%' — Interactive
– Interactive, Commented Apr 9, 2015 at 13:53
I didn't "miss" it, you didn't provide that important bit of code in your question, that's why I said that. — Funk Forty Niner
– Funk Forty Niner, Commented Apr 9, 2015 at 13:54
I didn't say that you missed it by overreading it but missed it because I didn't provide it. However it's there now :-) — Interactive
– Interactive, Commented Apr 9, 2015 at 13:57

Interactive · Accepted Answer · 2015-04-13 12:02:03Z

1

Why you don`t extract them directly with SQL?

$query = "SELECT user_id, meta_value as name 
          FROM $wpd->usermeta 
          WHERE meta_key 
          LIKE 'first_name' 
          AND user_id 
          IN (SELECT user_id 
              FROM $wpdb->usermeta 
              WHERE meta_key='provincie' 
              AND ( ".$provincie_check.")) 
              ORDER BY name";

edited Apr 13, 2015 at 12:02

Interactive

1,5605 gold badges28 silver badges67 bronze badges

answered Apr 9, 2015 at 16:45

claudiosan

342 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Interactive Over a year ago

I like this. I will take a look. Thank you

Interactive Over a year ago

This did the trick for me. However can you explain why I should change the * with theuser_id and meta_value. I thought they were used to get those values and nothing else

Collectives™ on Stack Overflow

Wordpress/PHP/MySql sort results

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related