華崇家俱網
國外實績
國內實績
collid."' and b.subname2='none' and c.subname1='none' and d.catname='none' and showflag='Y'");
$r_levelitem1=mysql_fetch_object($q_levelitem1);
if (mysql_num_rows($q_levelitem1)>0)
echo "
collid.'","2");'."'>".$r_coll->collname."
"; else echo "".$r_coll->collname."
"; $q_cate=mysql_query("select catid,catname from category where collid='".$r_coll->collid."' and catname<>'none' order by collid,catid"); if (mysql_num_rows($q_cate)>0) echo "";
else
echo "
";
$q_countlevel1=mysql_query("select *
from category a, subcategory1 b
where a.catid=b.catid and a.collid='".$r_coll->collid."' and a.catname<>'none' and
b.subname1<>'none'");
if (mysql_num_rows($q_countlevel1)>0) {
echo "
";
}
while ($r_cate=mysql_fetch_object($q_cate)) {
$q_levelitem2=mysql_query("select *
from item a, subcategory2 b, subcategory1 c
where a.subcatid2=b.subcatid2 and b.subcatid1=c.subcatid1 and showflag='Y' and
a.catid='".$r_cate->catid."' and b.subname2='none' and c.subname1='none'");
$r_levelitem2=mysql_fetch_object($q_levelitem2);
if (mysql_num_rows($q_levelitem2)>0)
echo "
catid.'","2");'."'>".$r_cate->catname."
"; else echo "".$r_cate->catname."
"; $q_subcate1=mysql_query("select subcatid1,subname1 from subcategory1 where collid='$r_coll->collid' and catid='".$r_cate->catid."' and subname1<>'none' order by collid,catid,subcatid1"); if (mysql_num_rows($q_subcate1)>0) echo "";
else
echo "
";
}// $r_coll
?>
";
$q_countlevel2=mysql_query("select *
from subcategory1 a, subcategory2 b
where a.subcatid1=b.subcatid1 and a.catid='".$r_cate->catid."' and
a.subname1<>'none' and b.subname2<>'none'");
if (mysql_num_rows($q_countlevel2)>0) {
echo "
";
echo "";
}
while ($r_subcate1=mysql_fetch_object($q_subcate1)) {
$q_levelitem3=mysql_query("select *
from item a, subcategory2 b
where a.subcatid2=b.subcatid2 and showflag='Y' and
a.subcatid1='".$r_subcate1->subcatid1."' and b.subname2='none'");
$r_levelitem3=mysql_fetch_object($q_levelitem3);
if (mysql_num_rows($q_levelitem3)>0)
echo "
";
} // $r_cate
if (mysql_num_rows($q_countlevel1)>0)
echo "subcatid1.'","2");'."'>".$r_subcate1->subname1."
"; else echo "".$r_subcate1->subname1."
"; $cnt=1; $q_subcate2=mysql_query("select subcatid2,subname2 from subcategory2 where collid='$r_coll->collid' and catid='".$r_cate->catid."' and subcatid1='".$r_subcate1->subcatid1."' and subname2<>'none' order by collid,catid,subcatid1,subcatid2"); if (mysql_num_rows($q_subcate2)>0) echo "";
else
echo "
";
echo "";
while ($r_subcate2=mysql_fetch_object($q_subcate2)) {
$q_tot=mysql_query("select count(*) as item_num from item where subcatid2='".$r_subcate2->subcatid2."'");
$r_tot=mysql_fetch_object($q_tot);
$item_num=$r_tot->item_num;
echo "
";
} // $r_subcate1
if (mysql_num_rows($q_countlevel2)>0)
echo "subcatid2.'","2");'."'> ".$r_subcate2->subname2."
"; ++$cnt; } // $r_subcate2 echo "關於我們
連絡我們
回首頁
43346 台中市沙鹿區忠貞路324號