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.Pic_s as Pic_s,
ProdItem_enTB.Pic_b as Pic_b,
ProdItem_enTB.Remark as Remark,
ProdSeries_enTB.ID as SeriesID,
ProdSeries_enTB.ClassID as ClassID,
ProdSeries_enTB.SeriesName as SeriesName,
ProdClass_enTB.SeriesPic as SeriesPic,
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 ProdItem_enTB.ID=".$itemid;
}
$DB->query($query);
//if(!$DB->query($query)) die($DB->error());
$numrows = $DB->numRows();
if($numrows > 0){
$row = $DB->fetchObject();
$itemid = $row->ID;
$itemname = stripslashes($MErrB5->ModifyBack($row->ItemName));
if($row->ShowSeriesName!=''){
$show_seriesname= stripslashes($MErrB5->ModifyBack($row->ShowSeriesName));
}else{
$show_seriesname= stripslashes($MErrB5->ModifyBack($row->SeriesName)).' '.stripslashes($MErrB5->ModifyBack($row->ClassName));
}
$comparesale= $row->CompareSale;
$pic_s = stripslashes($row->Pic_s);
$pic_b = stripslashes($row->Pic_b);
$remark = stripslashes($MErrB5->ModifyBack($row->Remark));
$seriesid = $row->SeriesID;
$classid = $row->ClassID;
$seriesname = stripslashes($MErrB5->ModifyBack($row->SeriesName));
$seriespic = stripslashes($row->SeriesPic);
$classname = stripslashes($MErrB5->ModifyBack($row->ClassName));
?>
 ';
}else if($pic_s!=''){
echo ' | ';
}else{
echo ' | ';
}
?>
|
 ';
}else{
echo ' | ';
}
?>
|
|
|
 |
query($query2);
if(!$DB2->query($query2)) die($DB2->error());
$j = 0;
$numrows2 = $DB2->numRows();
/*while($row2 = $DB2->fetchObject()){
$titleid[$j] = $row2->ID;
$titlename[$j] = stripslashes($MErrB5->ModifyBack($row2->SizeTitle));
$j++;
}*/
if($numrows2>0){
?>
query($query2);
$row2 = $DB2->fetchObject();
if($row2 === false)
{
return false;
}
else
{
if($row2->OpenSale!=1) continue;
}*/
$query2 = "select ProdSize,TitleID,SizeTitle from ProdSize_enTB
left join ProdSizeTitle_enTB on ProdSize_enTB.TitleID=ProdSizeTitle_enTB.ID
where ProdSize_enTB.ItemID=".$itemid." and ProdSize_enTB.OpenSale=1 and ProdSizeTitle_enTB.ClassID=".$classid.
" order by ProdSizeTitle_enTB.ArrayNo,ProdSizeTitle_enTB.ID";
$DB2->query($query2);
while($row2 = $DB2->fetchObject()){
$titlename = stripslashes($MErrB5->ModifyBack($row2->SizeTitle));
?>
|
| ModifyBack($row2->ProdSize)); ?> |
|
|
|
| |
|
|
$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 '