
<?php
$prodplacelist = new WA_MySQLi_RS("prodplacelist", $cmctrfdb, 0);
$prodplacelist->setQuery("SELECT * FROM contacts_td WHERE contacts_td.idtd='$idtd' ORDER BY contacts_td.sitenumber");
$prodplacelist->execute();
?>
<?php
$totprodplace = $prodplacelist->TotalRows;
?>
<?php if ($totprodplace > 0) { ?>
<?php


    $pdf->SetFont('', 'B', '10');


    $pdf->Cell(190, 6, $chemicalagentpdf, 1, 0, 'C');

    $pdf->Ln();
    $pdf->SetFont('', '', '9'); ?>
<?php
    $wa_startindex = 0;
    while (!$prodplacelist->atEnd()) {
        $wa_startindex = $prodplacelist->Index;

        $companyname = convertToPDFEncoding($prodplacelist->getColumnVal("companyname"));
        $companyaddress = convertToPDFEncoding($prodplacelist->getColumnVal("address"));
        $companycity = convertToPDFEncoding($prodplacelist->getColumnVal("city"));
        $companycap = convertToPDFEncoding($prodplacelist->getColumnVal("cap"));
        $companycountry = convertToPDFEncoding($prodplacelist->getColumnVal("country"));
        $companytelephone = convertToPDFEncoding($prodplacelist->getColumnVal("telephone"));
        $companyemail = convertToPDFEncoding($prodplacelist->getColumnVal("email"));
        $contactname = convertToPDFEncoding($prodplacelist->getColumnVal("contactname"));
        $companyfax = convertToPDFEncoding($prodplacelist->getColumnVal("fax"));
        $pdf->Cell(190, 6, $companyname, 1, 0, 'L', TRUE);
        $pdf->Ln();

        $prodplacelist->moveNext();
    }
    $prodplacelist->moveFirst(); //return RS to first record
    unset($wa_startindex);
    unset($wa_repeatcount);


?><?php } ?>