$str = "select distinct a.merk, b.merk, a.tipekendaraan, c.tipekendaraan, a.jeniskendaraan, d.jeniskendaraan from gl_masterkendaraan as a left join gl_merkkendaraan as b on (a.merk=b.id) left join gl_tipekendaraan as c on (a.tipekendaraan=c.id) inner join gl_jeniskendaraan as d on (a.jeniskendaraan=d.id) "; //echo $str; if ($area != '') { $str .= " where a.area='{$area}'"; } $str .= " order by a.merk asc "; //echo $str; $query = mysql_query($str) or die(mysql_error()); //print_r($str); $no = 1; while (list($idmerk, $merk, $idtipe, $tipe, $idjenis, $jenis) = mysql_fetch_array($query)) { $pdf->SetX(0.25); /*$pdf->SetWidths(array(1,2,2,2)); $pdf->SetAligns(Array('C','C','C','C')); $pdf->Row(array("$no", "$merk", "$jenis", "$tipe"));*/ $h = $pdf->GetHeight(); $strsub = "select id, area from gl_area "; if ($area != '') { $strsub .= " where id='{$area}' "; } $strsub .= "order by area asc "; $querysub = mysql_query($strsub) or die(mysql_error()); while (list($idarea, $namaarea) = mysql_fetch_array($querysub)) { //$pdf->SetY($h); $pdf->SetX(7.25); $qcb = mysql_query("select id, gudang from gl_gudang where area = '{$idarea}' order by gudang asc") or die(mysql_error()); $jqcb = mysql_num_rows($qcb); if ($jqcb == '0') { $pdf->Cell(1, $h, "", 1, 0, 'C'); } else { while (list($idgudang, $namagudang) = mysql_fetch_array($qcb)) {