$qry_dtl = mysql_query($sql_dtl); $row_dtl = mysql_fetch_assoc($qry_dtl); $desc = $row_dtl['material']; break; case "accessory": $sql_dtl = "SELECT * FROM tbl_accessory WHERE accessory_id = '{$row_servicedtl['id']}' ORDER BY accessory_id LIMIT 0,1"; $qry_dtl = mysql_query($sql_dtl); $row_dtl = mysql_fetch_assoc($qry_dtl); $desc = $row_dtl['accessory']; break; default: break; } $servicedtl[] = array("desc" => $desc, "type" => $row_servicedtl['type'], "qty" => $row_servicedtl['qty'], "amount" => $row_servicedtl['amount']); } if ($numwo_mst == 0) { echo '<script>window.location="estimate_menu.php"</script>'; } $pdf = new PrintEstimate(); // Data loading $pdf->setCompanyInfo('FAST QUICK SERVICE', '#100 President Ave. BF Home Paranaque, City', '801-6291'); $pdf->setEstimateRefNo($estimaterefno, $transdate); $pdf->setMaster($servicemst); $pdf->setDetails($servicedtl); $pdf->setVehicleInfo($plateno, $model, $variant, $make, $color, $year); $pdf->setCustomerInfo($customername, $customeraddress, $customernumber, $customerfax, $customermobile); $pdf->AddPage(); $pdf->ImprovedTable(); // I = WEB VIEW, D = DOWNLOAD PDF FILE $pdf->Output($estimaterefno . '.pdf', 'I'); $_SESSION['estimaterefno'] = null;