Parsing redundant MySQL result into structured array

Question

my MySQL query output is

I wanna parse into struturized array like this:

arcol_a | arcol_b
dataA1 | dataB1
----------| dataB2
dataA2 | dataB3
----------| dataB4
----------| dataB5

thanks

jeroen · Accepted Answer · 2011-05-18 22:51:11Z

3

This should do it:

$desired_array = array();
foreach ($query_output as $value)
{
  $desired_array[$value['arcol_a']][] = $value['arcol_b'];
}

This way you add each value in the second column to an array with an index of the first column.

answered May 18, 2011 at 22:51

jeroen

91.8k22 gold badges118 silver badges132 bronze badges

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

Comments

zsalzbank · Accepted Answer · 2011-05-18 22:48:04Z

1

Make an hashtable called arcol_a_array.
Loop through your data. For each row, check and see if the current arcol_a value is a key in the arcol_a_array array. If not, add it. The value of this key should be an array with one element - the value of the current row's arcol_b
If the arcol_a value existed in the arcol_a_array hashtable, modify the array to add the new value from arcol_b.

answered May 18, 2011 at 22:48

zsalzbank

9,8611 gold badge28 silver badges39 bronze badges

Comments

Alex · Accepted Answer · 2011-05-18 22:51:49Z

1

$arr = array();

while($row = mysql_fetch_assoc($result)) {
   if(isset($arr[$row['arcol_a']])) {
    $arr[$row['arcol_a']][] = $row['arcol_b'];
  } else {
    $arr[$row['arcol_a']] = array($row['arcol_b']);
  }
}

answered May 18, 2011 at 22:51

Alex

3,0993 gold badges27 silver badges48 bronze badges

Collectives™ on Stack Overflow

Parsing redundant MySQL result into structured array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related