Someone can help me with a issue related with R&OS tool to generate PDF, well I am populating a table from a database, but when the pdf prinout is generated then only a empty table is sgowing, althoug I have debuging and it has data to showing.
please take a look to the att doc...
here is portion of code used to generate the pdf
Code: Select all
$field=$_GET['fld'];
$value=$_GET['tm'];
$result1= @mysql_query("SELECT * FROM hardware_inventory WHERE $field = $value ",$link);
$total = mysql_num_rows($result1);
$pdf->rectangle(10,600,550,200);
$pdf->rectangle(450,805,140,20);
//while($row = mysql_fetch_array($result1)) {
while($data[] = mysql_fetch_array($result1, MYSQL_ASSOC)) {}
$pdf->ezTable($data);
//Header
$pdf->addText(10,810,16,"<b>Hardware List Report</b>");
$pdf->addText(451,809,14,"P.C. NO.:");
$pdf->addText(515,809,14,$row["0"]);
//CUADRO 1
$pdf->addText(11,790,10,"PLANT LOCATION ");
$pdf->addText(11,770,10,$row["1"]);
$pdf->addText(110,790,10,"Department ");
$pdf->addText(110,770,10,$row["2"]);
$pdf->addText(170,790,10,"User Name ");
$pdf->addText(170,770,10,$row["3"]);
$pdf->addText(225,790,10,"PC Card Monitor ");
$pdf->addText(225,770,10,$row["4</br>"]);
// $pdf->addText(11,710,10,"Procesor Speed: ");
// $pdf->addText(110,710,10,$row["5"]);
//
//
// $pdf->addText(11,690,10,"Model Number: ");
// $pdf->addText(110,690,10,$row["6"]);
//
// $pdf->addText(11,670,10,"PC Name : ");
// $pdf->addText(110,670,10,$row["7"]);
//
//
// $pdf->addText(11,650,10,"Operating System: ");
// $pdf->addText(110,650,10,$row["8"]);
//}
$pdf->ezStream();