Within both the financials and finres tables I have resource, budget, eac, actual, month1, month2, month..., month24. I need to add the values of the budget, eac and actual columns and insert them into their respective finres columns.
That is working, however, the problem comes when I try to execute a for loop inside the while loop so that $month1[] is filled with all the different month1 values, and $month2[] is filled with all its values so I can call an array_sum($month1[]) and insert it into the finres table... if that makes sense?
here is my code, i'll highlight the bit where the trouble starts, unsure (and doubtful) as to whether the proceeding for loops (in green) will work
Code: Select all
//update budget, eac, actual etc into financial resources table
$sql = "SELECT * FROM " . $projectid . "_financials WHERE resource = '$resource'";
$addfin = @mysql_query($sql) or die('(F02) Error retrieving financials: ' . mysql_error());
while ($af = mysql_fetch_array($addfin)) {
$budget[] = $af['budget'];
$eac[] = $af['eac'];
$actual[] = $af['actual'];
[color=#FF0000]//insert individual month values into respective arrays[/color]
[color=#FF0000]for($i=1;$i<=24;$i++) {[/color]
$pre = 'month'.$i;
$$pre[$i] = $af["month$i"];
[color=#FF0000]I have tried putting in echo 'bob'; here but it doesn't even print bob.[/color]
}
}
//get sums of arrays
$sum_budget = array_sum($budget);
$sum_eac = array_sum($eac);
$sum_actual = array_sum($actual);
[color=#408000]for($i=1;$i<=24;$i++) {
$pre = 'sum_month'.$i;
$post = 'month'.$i;
$$pre = array_sum($$post);
} [/color]
//insert into finres table
$sql = "UPDATE " . $projectid . "_finres SET
budget = '$sum_budget',
actual = '$sum_actual',
eac = '$sum_eac'";
[color=#408000]for($i=1;$i<=24;$i++) {
$sum = 'sum_month'.$i;
$pre = 'month'.$i;
$sql .= ", ".$$pre." = '".$$sum;
}[/color]
$ok = @mysql_query($sql) or die("(F03) Financials Error: " . mysql_error());