$pdf = new fpdf('P', 'mm', 'Letter'); $pdf->setFont('Times', 'B', 20); $pdf->addPage(); $pdf->setY(20); $pdf->cell(0, 12, 'Bills from ' . $header, 0, 1, 'C'); $pdf->setY(40); $total = 0.0; while ($row = mysqli_fetch_array($billR, MYSQLI_NUM)) { $payer[$row[1]] = $row[0]; $total += $row[0]; } $num = mysqli_num_rows($payersR); $avg = $total / $num; $pdf->setFont('Times', 'B', 16); // 216 mm total, 203 writable $pdf->setX(7.5); $pdf->cell(75, 10, 'Name', 1, 0, 'C'); $pdf->cell(42, 10, 'Amount Paid', 1, 0, 'C'); $pdf->cell(42, 10, '', 1, 0, 'C'); $pdf->cell(42, 10, 'Amount', 1, 1, 'C'); $pdf->setFont('Times', '', 14); foreach ($payer as $name => $amount) { // 216 mm total, 203 writable $pdf->setX(7.5); $pdf->cell(75, 10, $name, 1, 0, 'L'); $pdf->cell(42, 10, "\$" . number_format($amount, 2), 1, 0, 'C'); $pdf->cell(42, 10, $amount - $avg > 0 ? 'Is Owed' : 'Owes', 1, 0, 'C'); $pdf->cell(42, 10, "\$" . number_format(abs($amount - $avg), 2), 1, 1, 'C'); } $pdf->setFont('Times', 'B', 14); // 216 mm total, 203 writable