20090824000000
GROUP BY ppl_id ORDER BY min ) bla
GROUP BY bla.dag
EOT
);
if (mysql_num_rows($result) == 0) exit;
$lasttime = mysql_result($result, 0, 0);
$date = date("d-m-Y", mysql_result($result, 0, 0));
$array['dag'][0] = $date;
$array['lln'][0] = mysql_result($result, 0, 1);
$array['doc'][0] = mysql_result($result, 0, 2);
$array['oud'][0] = mysql_result($result, 0, 3);
$day = 0;
for ($i = 1; $i < mysql_num_rows($result); $i++) {
while (strcmp($date, date("d-m-Y", mysql_result($result, $i, 0)))) {
$day++;
$lasttime += 24*60*60;
$date = $array['dag'][$day] = date("d-m-Y", $lasttime);
$array['lln'][$day] = $array['lln'][$day - 1];
$array['doc'][$day] = $array['doc'][$day - 1];
$array['oud'][$day] = $array['oud'][$day - 1];
}
$array['lln'][$day] += mysql_result($result, $i, 1);
$array['doc'][$day] += mysql_result($result, $i, 2);
$array['oud'][$day] += mysql_result($result, $i, 3);
}
?>
cached on '.date(DATE_ATOM)."\n\n\n");
fclose($fp);
rename($cachedir.'/graphics_aantal_accounts.html.tmp', $cachedir.'/graphics_aantal_accounts.html') or die('unable to move');
}
ob_end_flush(); ?>