|
|
|
|
|
|
| |
|
|
query($query);
$numrows = $DB->numRows();
if($numrows>0){
$row = $DB->fetchObject();
$seriesid =$row->ID;
}else{
$seriesid =0;
}
}else{
$query = "select ProdSeries_enTB.ID as ID
from ProdSeries_enTB left join ProdClass_enTB on ProdSeries_enTB.ClassID = ProdClass_enTB.ID
where ProdClass_enTB.ID<>1 and ProdClass_enTB.OpenSale=1 and ProdSeries_enTB.OpenSale=1
order by ProdClass_enTB.ArrayNo,ProdClass_enTB.ID,ProdSeries_enTB.ArrayNo,ProdSeries_enTB.SeriesName";
$DB->query($query);
$numrows = $DB->numRows();
if($numrows>0){
$row = $DB->fetchObject();
$seriesid =$row->ID;
}else{
$seriesid =0;
}
}
?>
| • Position> Products
query($query);
$numrows = $DB->numRows();
if($numrows>0){
$row = $DB->fetchObject();
$classid = $row->ClassID;
$title_pic =stripslashes($row->Title_Pic);
$title_flash =stripslashes($row->Title_Flash);
echo ' > '.stripslashes($MErrB5->ModifyBack($row->ClassName)).'';
echo ' > '.stripslashes($MErrB5->ModifyBack($row->SeriesName));
}
?>
|
|
|
1 and ProdItem_enTB.OpenSale=1 order by ProdSeries_enTB.ArrayNo,ProdSeries_enTB.ID,ProdItem_enTB.ArrayNo,ProdItem_enTB.ItemName";
}else{
$query = "select ProdItem_enTB.ID as ID,
ProdItem_enTB.ItemName as ItemName,
ProdItem_enTB.ShowSeriesName as ShowSeriesName,
ProdItem_enTB.CompareSale as CompareSale,
ProdItem_enTB.NewSale as NewSale,
ProdItem_enTB.NewUpDate as NewUpDate,
ProdItem_enTB.NewDownDate as NewDownDate,
ProdItem_enTB.Pic_s as Pic_s,
ProdItem_enTB.Remark as Remark,
ProdSeries_enTB.SeriesName as SeriesName,
ProdClass_enTB.ClassName as ClassName
from ((ProdItem_enTB left join ProdSeries_enTB on ProdItem_enTB.SeriesID = ProdSeries_enTB.ID)
left join ProdClass_enTB on ProdSeries_enTB.ClassID = ProdClass_enTB.ID)
where ProdClass_enTB.ID<>1 and ProdSeries_enTB.ID=".$seriesid." and ProdItem_enTB.OpenSale=1 order by ProdItem_enTB.ArrayNo,ProdItem_enTB.ItemName";
}
$DB->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 = 'prod_'.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 '