$this->Cell($w[0], 6, $row[0], 'LR', 0, 'L', $fill); $this->Cell($w[1], 6, $row[1], 'LR', 0, 'L', $fill); $this->Cell($w[2], 6, $row[2], 'LR', 0, 'L', $fill); $this->Cell($w[3], 6, $row[3], 'LR', 0, 'L', $fill); $this->Cell($w[4], 6, $row[4], 'LR', 0, 'L', $fill); $this->Cell($w[5], 6, number_format($row[5]), 'LR', 0, 'R', $fill); $this->Ln(); $fill = !$fill; } $this->Cell(array_sum($w), 0, '', 'T'); } } require_once 'connect.php'; $query = "select\n C.ComponentReference,\n C.ComponentValue,\n C.ComponentPartNumber,\n C.ComponentManufacturer,\n C.ComponentFootPrint,\n IFNULL(I.quantity,0) AS quantity\n from \n Inventory as I\n Right Join\n Component as C\n ON\n C.ComponentID = I.ComponentID\n "; $stmt = $conn->prepare($query); if ($stmt->execute()) { $stmt->setFetchMode(PDO::FETCH_ASSOC); } while ($result = $stmt->fetch()) { $data[] = array($result['ComponentReference'], $result['ComponentValue'], $result['ComponentPartNumber'], $result['ComponentManufacturer'], $result['ComponentFootPrint'], $result['quantity']); } date_default_timezone_set('America/Los_Angeles'); $pdf = new myPDF('L', 'mm', 'Letter'); $date = date("m/d/Y h:i A"); $pdf->date = $date; $header = array('Reference', 'Value', 'Part Number', 'Manufacturer', 'Foot Print', 'Quantity On Hand'); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->BuildTable($header, $data); $pdf->Output(); $conn = null;