Listing totals up until\n"; echo "

day/time = $curd/$curt

\n"; include "jopsdb.php"; $conn = db_connect(); if( !$conn ) { echo "Failed to connect to database server :("; exit(); } mysql_select_db( "Stats", $conn ); // $q = "select version,count(*) as 'Number of restarts',min(timeofday) as 'First time',max(timeofday) as 'Last time' from JCCSRestart group by version"; $q = "SELECT version,count(*) AS 'Number of restarts', date_format(timeofday,'%u %Y') as Week, sec_to_time( (((to_days(max(timeofday))*86400.0+ time_to_sec(extract(HOUR_SECOND FROM max(timeofday)))) - (to_days(min(timeofday))*86400.0+time_to_sec(extract(HOUR_SECOND FROM min(timeofday)))))/count(*)) ) as 'Average lifetime' from JCCSRestart GROUP BY date_format(timeofday,'%u'),version order by Week"; $result = mysql_query( $q, $conn ); if( !$result ) { echo "Failed to query database :("; exit(); } if( !mysql_num_rows($result) ) { echo "Bummer. No records found."; exit(); } echo "\n"; echo "\n"; $idcol = -1; $cnt = 0; $left = false; while( $cnt".mysql_field_name($result,$cnt)."\n"; $left = true; $cnt++; } echo "\n"; $nf = mysql_num_fields($result); while( ($row=mysql_fetch_row($result)) ) { echo "\n"; $fcnt = 0; $left = false; while( $fcnt<$nf ) { if( $fcnt!=$idcol ) { $class = "right"; if( $left ) { $class="left"; } echo " \n"; $left = true; } $fcnt++; continue; } echo "\n"; } ?>
".$row[$fcnt]."