Query result array modifying

Question

I got the following array , as a result from the MySQL query:

Array
(
    [0] => Array
        (
            [id] => 11
            [owner] => Mark
        )

    [1] => Array
        (
            [id] => 10
            [owner] => David
        )

    [2] => Array
        (
            [id] => 9
            [owner] => Poul
        )

    [3] => Array
        (
            [id] => 8
            [owner] => Peter
        )

    [4] => Array
        (
            [id] => 7
            [owner] => Peter
        )

    [5] => Array
        (
            [id] => 6
            [owner] => Lucas
        )

)

Is there a way to modify it, using the PHP functions and ommit the foreach process?

I would like it to look following:

Array
(
    11 => Mark
    10 => David
    9 => Poul
    8 => Peter
    7 => Peter
    6 => Lucas
)

So , basicly it should build this array from the id and the owner values. Like id => owner.

Is that possible?

Speaking of revealed secrets, perhaps the SQL code would be of use, to solve this... — Brad Werth
– Brad Werth, Commented Sep 12, 2012 at 23:26

kgarthai · Accepted Answer · 2012-09-12 23:31:15Z

2

If you're using PDO, you can do something like this:

$stmt = $dbh->query("SELECT id, owner FROM table");
$arr = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP);

This should give you an array, where the indices of the array are the values of the first column in your result, namely id.

answered Sep 12, 2012 at 23:31

kgarthai

1001 silver badge7 bronze badges

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

Comments

Nelson Benítez León · Accepted Answer · 2012-09-12 23:38:23Z

0

If your original array is $arr then the following code would alter it as you want:

$tot = count($arr);
for($i=0;$i<$tot;$i++) {
   $key = $arr[$i]['id'];
   $val = $arr[$i]['owner'];
   unset($arr[$i]);
   $arr[$key] = $val;
}

answered Sep 12, 2012 at 23:38

Nelson Benítez León

51k8 gold badges70 silver badges84 bronze badges

Collectives™ on Stack Overflow

Query result array modifying

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related