[RESOLVED] Gettin the total from values in a array

[imad_imike]

Hi, I have an array, storing numeric values from mysql database.

The problem is, how would i get the total of these values and echo the result im my table.

heres the query

$entryName[$entry] = array();
$entryID[$entry] = array();
$entryValue[$entry]	= array();	
$entrySelect[$entry] = array();
$entryBalanceSheet[$entry] = array();
$entryDate[$entry] = array();
$entryRW[$entry] = array();

//intangible
$IentryName[$entry] = array();
$IentryID[$entry] = array();
$IentryValue[$entry] = array();	
$IentrySelect[$entry] = array();
$IentryBalanceSheet[$entry] = array();
$IentryDate[$entry] = array();
$IentryTotal[$entry] = array();

//tangible
$TentryName[$entry] = array();
$TentryID[$entry] = array();
$TentryValue[$entry] = array();	
$TentrySelect[$entry] = array();
$TentryBalanceSheet[$entry] = array();
$TentryDate[$entry] = array();
$TentryTotal[$entry] = array();

$SQL = "SELECT * FROM AccPeriod WHERE UserID = '$userID' ORDER BY AccOpen ASC";
$result = mysql_query($SQL) or die(mysql_error());
$num_rows = mysql_num_rows($result);

$SQL1 = "SELECT * FROM Entry WHERE UserID = '$userID' AND EntryAdjustment IS NULL AND EntrySelect=4 AND EntryBalanceSheet=1";
$result1 = mysql_query($SQL1) or die(mysql_error());
$num_rows1 = mysql_num_rows($result1);
	$entry = 0;
	while ($row = mysql_fetch_array($result1))
	{		
		$entryName[$entry] = $row['EntryName'];
		$entryID[$entry] = $row['EntryID'];
		$entryValue[$entry]	= $row['EntryValue'];	
		$entrySelect[$entry] = $row['EntrySelect'];
		$entryBalanceSheet[$entry] = $row['EntryBalanceSheet'];
		$entryDate[$entry] = $row['EntryDate'];
		$entryRW[$entry] = $row['EntryRW'];


		if($entrySelect[$entry] ==4 && $entryBalanceSheet[$entry] ==1) 
		{
			$IentryName[$entry] = $entryName[$entry];
			$IentryID[$entry] = $entryID[$entry];
			$IentryValue[$entry] = $entryValue[$entry];	
			$IentrySelect[$entry] = $entrySelect[$entry];
			$IentryBalanceSheet[$entry] = $entryBalanceSheet[$entry];
			$IentryDate[$entry] = $entryDate[$entry];
			$IentryTotal[$entry] = $IentryTotal[$entry] + $IentryValue[$entry];
		}
	$entry ++;
 	$num_rows1 = $entry;			
}
	

Im tring to get the total value of $IentryValue[$entry].

Also, I'm displaying the rest of variables in a table and a loop, but if I contain it in the loop, I think it will just repeat itself, not 100% sure though.

Any help is appreciated

[anoopmail]

. . . 
 $entry ++;
           $num_rows1 = $entry;            

} 
$sum = 0;
foreach( $IentryValue as $value){
  $sum = $value+sum ;
}
echo $sum ;

[imad_imike]

anoopmail;10986596 wrote:

. . . 
 $entry ++;
           $num_rows1 = $entry;            

} 
$sum = 0;
foreach( $IentryValue as $value){
  $sum = $value+sum ;
}
echo $sum ;

when I tried this, it gave me blank screen, so I added [$entry] on the end of the variable and now it echos 0.

I know that the variable has numeric values in it because it is echoed elsewere in the script and shows the correct value.

I'm just having loads of problems getting the totals from this array

oh and I also added a $ in front of sum.

[anoopmail]

that's strange. try

$sum = 0;
echo '<pre>' ;
print_r($IentryValue);
echo '</pre>' ;
foreach( $IentryValue as $value){
  $sum = $value+sum ;
}
echo $sum ; 

[johanafm]

imad imike;10986599 wrote:

when I tried this, it gave me blank screen

A blank screen is usually an indication of error reporting being turned off while having a parse error.

Turn on error_reporting and specify a valid file for log_errors, and also set your development environment to use stderr for display_errors.

[imad_imike]

anoopmail;10986602 wrote:

that's strange. try

$sum = 0;
echo '<pre>' ;
print_r($IentryValue);
echo '</pre>' ;
foreach( $IentryValue as $value){
  $sum = $value+sum ;
}
echo $sum ; 

Thanks, great help, got this working now.

I'll change to resolved