//create the list of previously selected ids to get info from db $ids = ""; for ($i = 0; $i < count($selitems); $i++) { $ids .= "'" . $selitems[$i] . "'"; if ($i < count($selitems) - 1) { $ids .= ", "; } } //$sql="SELECT items.id,model,sn,sn3,itemtypeid,dnsname,ipv4,ipv6,label, agents.title as agtitle FROM items,agents ". // " WHERE agents.id=items.manufacturerid AND items.id in ($ids) order by itemtypeid, agtitle, model,sn,sn2,sn3"; $sql = "SELECT items.id,model,sn,sn3,itemtypeid,dnsname,ipv4,ipv6,label, agents.title as agtitle FROM items,agents " . " WHERE agents.id=items.manufacturerid AND items.id in ({$ids}) order by items.id"; $sth = db_execute($dbh, $sql); $idx = 0; $pdf = new PDF_Label(array('paper-size' => "{$labelpapersize}", 'metric' => 'mm', 'marginLeft' => $lmargin, 'marginTop' => $tmargin, 'NX' => $cols, 'NY' => $rows, 'SpaceX' => $hpitch - $lwidth, 'SpaceY' => $vpitch - $lheight, 'width' => $lwidth, 'height' => $lheight, 'font-size' => $fontsize)); $pdf->AddPage(); $pdf->SetAuthor('ITDB Asset Management'); $pdf->SetTitle('Items'); $pdf->setFontSubsetting(true); $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); /* skip specified labels, to avoid printing on missing label positions on reused papers*/ for ($skipno = 0; $skipno < $labelskip; $skipno++) { $pdf->Add_Label("", "", 0, 255, "", 0, 0, 6, 6); } $pages = 0; for ($row = 1; $row <= $rows; $row++) { if ($pages > 30) { break; } for ($col = 1; $col <= $cols; $col++) { $r = $sth->fetch(PDO::FETCH_ASSOC);