$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 $pdf->setX(7.5); $pdf->cell(75, 10, 'Total Paid', 1, 0, 'L'); $pdf->cell(42, 10, '$' . number_format($total, 2), 1, 0, 'C'); $pdf->cell(42, 10, 'Average Paid', 1, 0, 'L'); $pdf->cell(42, 10, '$' . number_format($avg, 2), 1, 1, 'C'); $result = mysqli_query($dbc, $query); if ($result) { // If there are bills. // 216 mm total, 203 writable $pdf->setY($pdf->getY() + 20); $pdf->setFont('Times', 'B', 16); $pdf->setX(7.5); $pdf->cell(75, 10, 'Description', 1, 0, 'C'); $pdf->cell(42, 10, 'Amount Paid', 1, 0, 'C'); $pdf->cell(42, 10, 'Paid By', 1, 0, 'C'); $pdf->cell(42, 10, 'Paid Date', 1, 1, 'C'); $pdf->setFont('Times', '', 14); if (mysqli_num_rows($result) != 0) { $grandtotal = 0.0; while (list($id, $date, $amount, $description, $name) = mysqli_fetch_array($result, MYSQLI_NUM)) { // 216 mm total, 203 writable $pdf->setX(7.5); $pdf->cell(75, 10, $description, 1, 0, 'L'); $pdf->cell(42, 10, "\$" . number_format($amount, 2), 1, 0, 'C'); $pdf->cell(42, 10, $name, 1, 0, 'C');