Creating an associative array from Wordpress $wpdb->get_results

Question

It's been a long day and for some reason this is totally eluding me...

My Wordpress database request looks like this:

$results = $wpdb->get_results($sql);

And the output looks like this

Array ( [0] => stdClass Object ([id] => 2 [organisation] => Company 2 ) 
        [1] => stdClass Object ([id] => 1 [organisation] => Company 1 ) 
)

I need to turn it into an array that looks like this:

Array ([1] => Company 1, [2] => Company 2)

This must be dead easy, but I just can't see it for some reason...Grateful for any pointers...

unity100 · Accepted Answer · 2018-09-16 16:50:23Z

10

Why dont you just request as an array in the first place

$results = $wpdb->get_results($sql,ARRAY_A);

return will be an array. if its one level deeper than you want, you can just do

$myarray = $results[0];

and you have it.

update: per Chris Sprauge's comment: ARRAY_A is a WP constant which you have to give as it is. It is not an associative array parameter.

answered Feb 26, 2015 at 22:05

unity100

79210 silver badges17 bronze badges

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

1 Comment

FYI for anybody wondering what ARRAY_A is ... it's a WordPress constant, not an array you have to pass

Rohit Choudhary · Accepted Answer · 2014-07-31 17:55:28Z

0

$array = array();
foreach ($results as $res){
    $array[] = $res->organisation;
}

answered Jul 31, 2014 at 17:55

Rohit Choudhary

2,2571 gold badge24 silver badges35 bronze badges