|
 |
Please
select
the comparable
products
from
the bellowed
table
(minimum:
2 models
maximum:
4 models) |
|
query($query);
//if(!$DB->query($query)) die($DB->error());
$title_count = $DB->numRows();
if($title_count>0){
$i=0;
while($row = $DB->fetchObject()){
$title_id[$i] = $row->ID;
$title_name[$i] = stripslashes($MErrB5->ModifyBack($row->SizeTitle));
$i++;
}
}
//*******************
$query = "select ProdItem_enTB.ID as ID,
ProdItem_enTB.ItemName as ItemName,
ProdItem_enTB.Pic_s as Pic_s
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=".$classid." and ProdItem_enTB.OpenSale=1 and ProdItem_enTB.CompareSale=1 order by ProdSeries_enTB.ArrayNo,ProdSeries_enTB.SeriesName,ProdItem_enTB.ArrayNo,ProdItem_enTB.ItemName";
$DB->query($query);
//if(!$DB->query($query)) die($DB->error());
$numrows = $DB->numRows();
?>
 |
Click |
 |
|
|
| |
|
|
|
|
|
|
