if(in_array($browser, $uniqueBrowser)) {
if(in_array($version, $uniqueBrowser[$browser])) {
$uniqueBrowser[$browser][$version]['times'] = $uniqueBrowser[$browser][$version]['times'] + 1;
} else {
$uniqueBrowser[$browser]['version'] = $version;
$uniqueBrowser[$browser][$version]['times'] = 1;
}
} else {
$uniqueBrowser[] = $browser;
$uniqueBrowser[$browser]['version'] = $version;
$uniqueBrowser[$browser][$version]['times'] = 1;
}
Browser data: array(4) {
[0]=>
string(7) "Firefox"
["Firefox"]=>
array(3) {
["version"]=>
string(6) "14.0.1"
[15]=>
array(1) {
["times"]=>
int(2)
}
["14.0.1"]=>
array(1) {
["times"]=>
int(15)
}
}
[1]=>
string(17) "Internet Explorer"
["Internet Explorer"]=>
array(2) {
["version"]=>
string(9) "8.0.0.253"
["8.0.0.253"]=>
array(1) {
["times"]=>
int(1)
}
}
}
+---------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| browser | varchar(120) | YES | | NULL | |
| version | varchar(50) | YES | | NULL | |
+---------+------------------+------+-----+---------+----------------+
+----+---------+---------+
| id | browser | version |
+----+---------+---------+
| 1 | Firefox | 3.6 |
| 2 | Firefox | 4.1 |
| 3 | Firefox | 3.6 |
| 4 | Safari | 5.1.7 |
| 5 | Safari | 6 |
| 6 | Firefox | 14.0.1 |
| 7 | IE | 7 |
| 8 | IE | 8 |
| 9 | IE | 7 |
| 10 | Firefox | 14.0.1 |
| 11 | Opera | 12.0.1 |
| 12 | Safari | 5.1.7 |
+----+---------+---------+
mysql> SELECT browser, version, COUNT(version) AS times FROM demo.browsers GROUP BY browser;
+---------+---------+-------+
| browser | version | times |
+---------+---------+-------+
| Firefox | 3.6 | 5 |
| IE | 7 | 3 |
| Opera | 12.0.1 | 1 |
| Safari | 5.1.7 | 3 |
+---------+---------+-------+
mysql> SELECT browser, version, COUNT(version) AS times FROM demo.browsers GROUP BY browser, version;
+---------+---------+-------+
| browser | version | times |
+---------+---------+-------+
| Firefox | 14.0.1 | 2 |
| Firefox | 3.6 | 2 |
| Firefox | 4.1 | 1 |
| IE | 7 | 2 |
| IE | 8 | 1 |
| Opera | 12.0.1 | 1 |
| Safari | 5.1.7 | 2 |
| Safari | 6 | 1 |
+---------+---------+-------+
foreach ($uniqueBrowser as $browserName=>$values){
echo $browserName .' contains '. print_r($values,true);
}