[SOLVED] Counting multi-dimensional array

[chaking]

I have the following array and I need to get the count for how many times each appears in the array.  So basically during the loop it will add to the $ccc array the machine id, devid, inputdevid, eventtype and eventid - I'm looking for how many are exact matches and then output that sum and keep the information (machine, devid, inputdevid etc..). 

 

<?php
while ($row = mssql_fetch_assoc($qq)) {
$ccc[] = array('machine' => $row['MACHINE'], 'devid' => $row['DEVID'], 'inputdevid' => $row['INPUTDEVID'], 'eventtype' => $row['EVENTTYPE'], 'eventid' => $row['EVENTID']);

}

?>

 

 

I previously did it by using something along the lines of:

<?php
while ($row = mssql_fetch_assoc($q2)) {
  $ccc[$row['MACHINE']][$row['DEVID']][$row['INPUTDEVID']][$row['EVENTTYPE']][$row['EVENTID']][] = 1;
}
foreach ($ccc as $qq => $qqq) {
foreach ($qqq as $qqqq => $qqqqq) {
	foreach ($qqqqq as $qqqqqq => $qqqqqqq) {
		foreach ($qqqqqqq as $qqqqqqqq => $qqqqqqqqq) {
			foreach ($qqqqqqqqq as $qqqqqqqqqqq => $gg) {
				$i = 0;
				$i = count($zz["$qq"]["$qqqq"]["$qqqqqq"]["$qqqqqqqq"]["$qqqqqqqqqqq"]);
				$zzz["$qq"]["$qqqq"]["$qqqqqq"]["$qqqqqqqq"]["$qqqqqqqqqqq"] = $i;

			}
		}
	}
}
}

?>

 

But I don't like that way and it leads to some other issues (sorting the resulting array ($zzz) from highest to lowest so that I can get a top 10).

 

Any ideas or suggestions would be very much appreciated. Thanks

[Psycho]

<?php
while ($row = mssql_fetch_assoc($qq)) {
$ccc[] = array(
	'machine'    => $row['MACHINE'],
	'devid'      => $row['DEVID'],
	'inputdevid' => $row['INPUTDEVID'],
	'eventtype'  => $row['EVENTTYPE'],
	'eventid'    => $row['EVENTID']
);
$machines[]   = $row['MACHINE'];
$devid[]      = $row['DEVID'];
$inputdevid[] = $row['INPUTDEVID'];
$eventtype[]  = $row['EVENTTYPE'];
$eventid[]    = $row['EVENTID'];
}

$machinesCount   = array_count_values($machines);
$devidCount      = array_count_values($devid);
$inputdevidCount = array_count_values($inputdevid);
$eventtypeCount  = array_count_values($eventtype);
$eventidCount    = array_count_values($eventid);

//The count arrays will be in this format
//array (
//  'value1' => 4, // <-- the number will be how many times
//  'value2' => 1, //     that value appears in the array
//  'value3' => 6,
//  'value4' => 3,
//)
?>

[chaking]

fantastic - thanks for the quick response mjdamato

[chaking]

Actually, that's outputting the number of times that specific machine or devid et al. shows up in the array, but it's the combination that matters... So let's say:

Machine = 4

devid = 20

inputdevid = 11

eventtype = 4

eventid = 0

 

What I need to match is how many times all of those values are matched exactly together.  If the eventid changes to 1, that would be a separate match/count.

 

I'm thinking maybe I should just put them all under 1 key with a csv or some delimiter and then just explode in while iterating through a loop and match that way?

[chaking]

Ahh, I think I'll just use an sql statement to get the count for each of them - Thanks

[chaking]

In case anyone is interested, here's how it ended up:

 

<?php
while ($row = mssql_fetch_assoc($qq)) {
$c[] = $row['MACHINE'] . "-" . $row['DEVID'] . "-" . $row['INPUTDEVID'] . "-" . $row['EVENTTYPE'] . "-" . $row['EVENTID'];
}

$d = array_count_values($c);
$g = array_unique($c);
foreach ($g as $e => $f) {
$zz["$f"] = $d["$f"];
}
arsort($zz);
foreach ($zz as $aa => $xx){
list($a1, $a2, $a3, $a4, $a5) = explode("-",$aa);

$sql6 = "SELECT READERDESC FROM READER WHERE PANELID = '" . $a1 . "'";
$sql6 .= " AND READERID = '" . $a2 . "'";
$tttt = mssql_query($sql6, $cxn2);
$row6 = mssql_fetch_assoc($tttt);

$sql7 = "SELECT NAME FROM ALARMINPUT WHERE PANELID = '" . $a1 . "'";
$sql7 .= " AND ALARMPID = '" . $a2 . "' AND INPUTID = '";
$sql7 .= $a3 . "'";
$ttttt = mssql_query($sql7, $cxn2);
$row7 = mssql_fetch_assoc($ttttt);

echo $xx . " | " . $row6['READERDESC'] . " | " . $row7['NAME'] . " | " . $bb[$a4][$a5] . "<br />";
}
?>