1 and ProdItemTB.OpenSale=1 order by ProdSeriesTB.ArrayNo,ProdSeriesTB.ID,ProdItemTB.ArrayNo,ProdItemTB.ItemName";
}else{
$query = "select ProdItemTB.ID as ID,
ProdItemTB.ItemName as ItemName,
ProdItemTB.ShowSeriesName as ShowSeriesName,
ProdItemTB.CompareSale as CompareSale,
ProdItemTB.Pic_s as Pic_s,
ProdItemTB.Pic_b as Pic_b,
ProdItemTB.Remark as Remark,
ProdSeriesTB.ID as SeriesID,
ProdSeriesTB.SeriesName as SeriesName,
ProdClassTB.SeriesPic as SeriesPic,
ProdClassTB.ClassName as ClassName
from ((ProdItemTB left join ProdSeriesTB on ProdItemTB.SeriesID = ProdSeriesTB.ID)
left join ProdClassTB on ProdSeriesTB.ClassID = ProdClassTB.ID)
where ProdItemTB.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;
$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());
$numrows2 = $DB2->numRows();
$pagesize = $numrows2;
$startrow = 0;
$endrow = $numrows2-1;
if($numrows2>0){
$j=$startrow;
?>
 |
$endrow) break;
$DB2->dataSeek($j);
?>
| |
fetchObject()){
if($row2->File_Pdf!=''){
?>
| ModifyBack($row2->SubItemName)); ?> |
 |
|
dataSeek($j);
if($row2 = $DB2->fetchObject()){
if($row2->File_Pdf!=''){
?>
| ModifyBack($row2->SubItemName)); ?> |
|
|
dataSeek($j);
if($row2 = $DB2->fetchObject()){
if($row2->File_Pdf!=''){
?>
| ModifyBack($row2->SubItemName)); ?> |
|
|
| |
|
|
|
|
|
query($query2);
//if(!$DB2->query($query2)) die($DB2->error());
$numrows2 = $DB2->numRows();
if($numrows2>0){
?>
 |
| |
dwg |
dxf |
view |
fetchObject()){
if($row2->File_Dwg!='' || $row2->File_Dxf!='' ||$row2->File_View!=''){
?>
| ModifyBack($row2->SubItemName)); ?> |
File_Dwg!=''){
echo ' | ';
}else{
echo ' | ';
}
if($row2->File_Dxf!=''){
echo ' | ';
}else{
echo ' | ';
}
if($row2->File_View!=''){
echo ' | ';
}else{
echo ' | ';
}
?>
|
| |
|
|
|
$query2 = "select ID from ProdMarkTB where ItemID=".$itemid." and OpenSale=1";
$DB2->query($query2);
$numrows2 = $DB2->numRows();
if($numrows2>0){
echo '
