mysql and php associative array

Question

I have this table:

Username,     Fan,        Count
1danny22,     katana1973, 2
bob,          rita,       2
mattyhacky,   hayley,     2
mattyhacky,   dickie1eye, 1
mattyhacky,   xxjodiexx,  1

And I want to load it into an associative array which would looks like this:

Array ( 
    [1danny22] => Array (
        [katana1973] => 2,
    ),
    [bob] => Array (
        [rita] => 2, 
    ),
    [mattyhacky] => Array (
        [hayley] => 2,
        [dickie1eye] => 1,
        [xxjodiexx] = > 1,
    )
)

$strSQL = "SELECT username, fan, count( * ) AS intCount
FROM fan
GROUP BY username, fan              
ORDER BY username, intCount DESC";

$strResult = mysql_query($strSQL);
while($objRow=mysql_fetch_object($strResult))
{
  code should go in here!!!
}

But I'm really struggling.

Can someone please help?

Many thanks

TheBounder.

Struggling with what? What have you tried so far?

Sascha Galley
– Sascha Galley

2011-07-12 19:51:08 +00:00
Commented Jul 12, 2011 at 19:51 — Sascha Galley
– Sascha Galley, Commented Jul 12, 2011 at 19:51

Patrick · Accepted Answer · 2011-07-12 19:54:07Z

4

Easy peasy...

$sql = "SELECT Username, Fan, Count FROM datatbl";
$res = mysql_query($sql);

while ($row = mysql_fetch_object($res))
  $data[$row->Username][$row->Fan] = $row->Count;

I should explain further. What your doing here is creating a base index for your data array that uses the common associate Username as the index. Within that index you have another array, this using the Fan as the index and the value of each item being the count. My above example is the easiest way to build the structure that you are looking at.

Now if you run a print_r on the array you will see the structure you defined.

answered Jul 12, 2011 at 19:54

Patrick

3,4714 gold badges33 silver badges48 bronze badges

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

Comments

Jerome WAGNER · Accepted Answer · 2011-07-12 19:54:55Z

2

assuming your initial array is in $data, with for instance

$data[0] = array("1danny22", "katana1973", 2);

you could go with

$output = array();
foreach($data as $line) {
    $output[$line[0]][$line[1]] = $line[2];
}

answered Jul 12, 2011 at 19:54

Jerome WAGNER

22.6k10 gold badges64 silver badges79 bronze badges

Comments

picus · Accepted Answer · 2011-07-12 19:55:38Z

0

You could build it programmatically from the returned result... bare bones example:

$ar = array();
$result = mysql_query("SELECT * FROM your_table");
while ($ar[] = mysql_fetch_assoc($result));


print_r($ar);

answered Jul 12, 2011 at 19:55

picus

1,5372 gold badges14 silver badges23 bronze badges

Collectives™ on Stack Overflow

mysql and php associative 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