$ch1 = ""; while ($querycpu_row = mysql_fetch_assoc($querycpu)) { $date = $querycpu_row['date']; $used = $querycpu_row['used']; if ($chd != "") { $chd = $chd . "," . $used; } else { $chd = $chd . $used; } if ($ch1 != "") { $ch1 = $ch1 . "|" . $date; } else { $ch1 = $ch1 . $date; } } $pdf->Cell(40, 40, $pdf->Image("http://chart.googleapis.com/chart?cht=lc&chd=t:{$chd}&chs=1000x300&chl={$ch1}&chco=FF0000&chxt=x,y", $pdf->GetX(), $pdf->GetY(), 280, 100, 'PNG'), 0, 0, 'L', false); $pdf->Ln(100); $pdf->SetFont('Times', '', 11); $pdf->Cell(0, 10, 'Server: ' . $hostname, 0, 1, 'C'); $pdf->AddPage(); } } } if ($query = mysql_query("SELECT distinct server FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******' group by server")) { $pdf->Cell(0, 10, 'CPU wait time', 0, 1, 'L'); $pdf->TOC_Entry('CPU wait time', 2); while ($query_row = mysql_fetch_assoc($query)) { $hostname = $query_row['server']; $cpuquery = mysql_query("select distinct date(cpurep.date)as date, max(cpurep.iowait) as used from cpurep,configureddb WHERE cpurep.dbid=configureddb.dbuid and server='{$hostname}' and date(date)>date(date_sub(now(), interval 1 month)) group by date(cpurep.date)order by date(cpurep.date) desc limit 31"); if (mysql_num_rows($cpuquery)) { $pdf->TOC_Entry($hostname, 3);