multidimension array

[richardw]

I need some help here,
Here is the problem.
I had summaries the rows of hours:minute of a day in an array, next I try to add them together to get total hours per week.

example of result in print_r:

Array ( [0] => 114:00 ) Array ( [0] =>111:00 ) Array ( [0] => ) Array ( [0] => ) Array ( [0] => 195:58 ) Array ( [0] => 202:19 )

[matto]

$mins = 0;
for($i=0; $i<count($array); $i++)
{
  $value = $array[$i][0];
  $parts = explode(':', $value);
  $mins += $parts[0]*60 + $parts[1];
}

$hours = $mins / 60;
echo "$hours hours";

hope this is what you need.

[adamgeorge]

ok, well just use some loops

for($i=0; $i<count($aArray); $i++)
   for($j=0; $j<count($aArray[$i]); $j++)
       $total += $aArray[$i][$j];

er... it is a two dimensional array right? I wasn't sure I understood your print_r statements.

Were all of those array ([0]->) blah blah part of the print_r of one array? or are you doing a loop and printing out the array each time?

You should really provide more code then that. It's hard to work out what you're doing.

[adamgeorge]

Er, don't listen to me actually, I think matto has the answer right there.

[richardw]

Thanks motto,

I still can't get it, I should had provide more. I am really stuck, I guess some different opinions and suggestion, since I had work on it for days.

here is the quote
//-------------------------------------
for($i=0; $i<$numDay; $i++) { // loop number of days selected by user on any selected date, month or year

$thisDay=date('Y-m-d', mktime(0,0,0,$thisMonthStart, $thisDayStart+$i, $thisYearStart));
$scoreDaily=array();
$scoreWeekly=array();
foreach($thisCard as $key=>$val) {

$query_3="SELECT score FROM report_manhours WHERE cardnumber='$val' AND date='$thisDay' ";
$result_3= $mysqld -> query($query_3);
if ($result_3==true) {
if(mysql_num_rows($result_3)>=1) {
while($rows_3=mysql_fetch_row($result_3)) {
$scoreDaily[] = $rows_3[0];
}//endwhile
}//endif
}//endifresult_3
}//endforeach
if($numDay==1) {
echo(countDailyScore($score)); // TOTAL SCORE PER DAY ;
}else{
$dayScore[$i]= (countDailyScore($score));
if(!empty($dayScore[$i])) {
echo(substr($days[$i],0,3).':'.$dayScore[$i]);
if(!isset($mins)) {
$mins='';
}
$parts = explode(':', $dayScore[$i]);
$mins[$i] += $parts[0]*60 + $parts[1];
}
}

[richardw]

Sorry I miss the function for the above posting:

function _countDailyScore($score) {
$hour=array();
$min =array();
$thisScore=array();
foreach($score as $key=>$val) {
if(!empty($val)) {
list($hour[],$min[])=explode(':',$val);
$totalMin = array_sum($min);
$totalHour = array_sum($hour);
$hourWithDec = $totalMin/60;
$carryOverHour = floor($hourWithDec);
$remMin = ($hourWithDec-$carryOverHour) * 60;
$remMin = sprintf("%02d",$remMin );
$thisScore[] = $totalHour+$carryOverHour.':'.$remMin;
}
}//endforeach
if(!empty($thisScore)) {
$last= end($thisScore);
Return $last;
}//endif
}//endfunc

// these will return the last element of the array for the days.
// so far upto here the result is ok... but when I add the score
// for the week .. the result is not seen correct , if I have many
// different cardnumber to loop again.

• note the field data is an array of not fix number of time values storaged in the table like
  0:01,5:00,8:00,11:00, 15:00, 20:11,23:59, some with more values and others with less.