query($query);
//if(!$DB->query($query)) die($DB->error());
$numrows = $DB->numRows();
$pagesize = 8;
if(@$_GET['topage']){
$topage = $_GET['topage'];
}else if(@$_POST['topage']){
$topage = $_POST['topage'];
}else{
$topage = NULL;
}
$Page = new AllotPage($numrows,$pagesize);
$pagecount = $Page->getTatlePage();
$currentpage = $Page->getCurrentPage($topage);
$startrow = $Page->getStartRow();
$endrow = $Page->getEndRow();
if($numrows > 0){
$DB->dataSeek($startrow);
for($i=$startrow;$i<=$endrow;$i++){
$row = $DB->fetchObject();
?>
Pic_s!=''){
$firsrinfo = 'specialprod_'.Ck_FirstInfo($row->ID,$DB2).'.php';
echo ' | ';
}else{
echo ' | ';
}
?>
|
|
|
|
|
$query2 = "select ID from ProdSize_enTB where ItemID=".$row->ID." and OpenSale=1";
$DB2->query($query2);
$numrows2 = $DB2->numRows();
if($numrows2>0){
echo '
$query2 = "select ID from ProdOrderNo_enTB where ItemID=".$row->ID." and OpenSale=1";
$DB2->query($query2);
$numrows2 = $DB2->numRows();
if($numrows2>0){
echo '
$query2 = "select ID from ProdFitment_enTB where ItemID=".$row->ID." and OpenSale=1";
$DB2->query($query2);
$numrows2 = $DB2->numRows();
if($numrows2>0){
echo '
if($row->CompareSale=='1'){
echo '
$query2 = "select ID from ProdDownPdf_enTB where ItemID=".$row->ID." and OpenSale=1";
$DB2->query($query2);
$numrows2 = $DB2->numRows();
if($numrows2>0){
echo '