Order by Fadderbarn.Area DESC
";
$result = $db->Query($query);
$data = array();$tot = 0;
while($row = $db->GetRow($result)) {$tot += $row["publicKr"];
$data[] = $row;
}
//add a totals row...
$row = array();
$row["publicKr"] = "<b>".$tot."</b>";$row["Fadderbarn.Name"] = "Total";
$data[] = $row;
$pdf->ezText("<b>VERY IMPORTANT! Trosgnistan have increased the support for most of the children from last year. See the list. Be sure that 90% of the support reach the children. Please read the new text.</b>");
$pdf->ezSetDy(-30);
$pdf->ezText("Children list $area $areaName");
$pdf->ezSetDy(-15);
$pdf->ezTable(
$data
//columns
,array('Fadderbarn.Area1'=>'<b>Area</b>'
,'Fadderbarn.Id'=>'<b>Childno.</b>'
,'Fadderbarn.Name'=>'<b>Name of Child</b>'
,'Giver.Id'=>'<b>Sponsor</b>'
,'Giver.Name'=>'<b>Givare</b>'
,'publicKr'=>'<b>Sek p/mon.</b>'
)
,""
//options
