2D / 3D
 
1 and ProdItem_enTB.OpenSale=1 and ProdItem_enTB.NewSale=1 and ProdItem_enTB.NewHomeSale=1 and ProdItem_enTB.NewUpDate<='".date("Y-m-d")."' and ProdItem_enTB.NewDownDate>='".date("Y-m-d")."' order by ProdItem_enTB.NewUpDate desc,ProdClass_enTB.ArrayNo,ProdClass_enTB.ID,ProdSeries_enTB.ArrayNo,ProdSeries_enTB.ID,ProdItem_enTB.ItemName,ProdItem_enTB.ID"; $DB->query($query); //if(!$DB->query($query)) die($DB->error); $numrows = $DB->numRows(); $pagesize = 4; $startrow = 0; $endrow = $numrows-1; if($numrows > 0){ $j=$startrow; for($i=0;$idataSeek($j); ?>
         
  fetchObject()){ ?> Pic_s!=''){ $firsrinfo = 'prod_'.Ck_FirstInfo($row->ID,$DB2).'.php'; echo ''; }else{ echo ''; } ?>
     ModifyBack($row->ClassName)); ?> ModifyBack($row->ItemName)); ?>
ModifyBack($row->Remark)); ?>
  dataSeek($j); if($row = $DB->fetchObject()){ ?> Pic_s!=''){ $firsrinfo = 'prod_'.Ck_FirstInfo($row->ID,$DB2).'.php'; echo ''; }else{ echo ''; } ?>
     ModifyBack($row->ClassName)); ?> ModifyBack($row->ItemName)); ?>
ModifyBack($row->Remark)); ?>
 
      More  
 
1 and ProdItem_enTB.OpenSale=1 and ProdItem_enTB.ModifyProd=1 and ProdItem_enTB.ModifyUpDate<='".date("Y-m-d")."' and ProdItem_enTB.ModifyDownDate>='".date("Y-m-d")."' order by ProdItem_enTB.ModifyDate desc,ProdClass_enTB.ArrayNo,ProdClass_enTB.ID,ProdSeries_enTB.ArrayNo,ProdSeries_enTB.ID,ProdItem_enTB.ItemName,ProdItem_enTB.ID"; $DB->query($query); //if(!$DB->query($query)) die($DB->error); $numrows = $DB->numRows(); $pagesize = 4; $startrow = 0; $endrow = $numrows-1; if($numrows > 0){ $j=$startrow; for($i=0;$idataSeek($j); ?>
         
  fetchObject()){ ?> Pic_s!=''){ //$firsrinfo = 'prod_'.Ck_FirstInfo($row->ID,$DB2).'.php'; //echo ''; echo ''; }else{ echo ''; } ?>
     ModifyBack($row->ClassName)); ?> ModifyBack($row->ItemName)); ?>
ModifyBack($row->Remark)); ?>
  dataSeek($j); if($row = $DB->fetchObject()){ ?> Pic_s!=''){ //$firsrinfo = 'prod_'.Ck_FirstInfo($row->ID,$DB2).'.php'; //echo ''; echo ''; }else{ echo ''; } ?>
     ModifyBack($row->ClassName)); ?> ModifyBack($row->ItemName)); ?>
ModifyBack($row->Remark)); ?>
 
      More