Menu
Anyone have this problem too? If so what’s the problem with it?
I have an excel spreadsheet which I’ve imported into MySQL to make my life easier in picking and choosing the specific columns and rows that I need.
When I sum it up in Excel it gives me 1 number, but when I use array_sum in PHP, it gives me a completely different number. I’ve tried to do a str_replace in case there were any spaces. I’ve checked to make sure that the # of rows matches as well.
Here’s what I’ve done so far…Maybe someone can help out by seeing the steps that I’ve done.
1.) Imported PayPal CSV sheet all with Varchar 500
2.) Added the following code to get array_sum
[code=php]
…..
$gross = array();
while ($jan_row = mysql_fetch_assoc($jan_result)) {
$gross[] = str_replace (” “, “”,$jan_row[‘Gross’]);
}
echo “Gross: “.array_sum($gross).”<br>”;
?>
3.) Tried it without any str_replace
4.) did a <pre><?php print_r($gross);?> </pre> -> copied all the values from it and pasted it into excel. Split the columns and summed it up in excel. Still didn’t get the same value as PHP array_sum
I’m sure it’s something stupid I’m missing here. If anyone can shed some light, that would be fantastic!