include("../../../fonran.php"); include("../../../twinner.php"); //echo "SELECT * FROM Product_Site_Classify WHERE Belong_SN = $Product_Site_Classify_SN1 AND Company_SN = $Company_SN ORDER BY Sort"; $Product_Site_Classify = new Recordset("SELECT * FROM Product_Site_Classify WHERE Product_Site_Classify_SN = $Product_Site_Classify_SN AND Company_SN = $Company_SN ORDER BY Sort") ; if ($Product_Site_Classify_SN == "") { $Product_Site_Classify_SN = $Product_Site_Classify->Field("Product_Site_Classify_SN"); } $Product = new Recordset("SELECT * FROM Product_Site_Classify WHERE Belong_SN = $Product_Site_Classify_SN AND Company_SN = $Company_SN ORDER BY Sort") ; if( $Page == "" ) { $Page = 1; } $Product->PageSize = 40;//GetParaMeter("PageSize") ; $Product->AbsolutePage( $Page ) ; $Company_Site = new Recordset("SELECT Site_SN, Company_Image_5, Company_BackGround_Color_6,Company_BackGround_Color_7 FROM Company_Site WHERE Company_SN=$Company_SN"); function Site_Classify( $Belong_SN , $Level ) { global $Company_SN ; global $productclass; $RS = new Recordset("SELECT * FROM Product_Site_Classify WHERE Company_SN = $Company_SN AND Product_Site_Classify_SN = $Belong_SN ORDER BY Sort") ; while( ! $RS->EOF ) { $productclass = $productclass . $RS->Field("Caption") . "\n\r" ; Site_Classify( $RS->Field("Belong_SN") , $Level + 1 ) ; $RS->MoveNext() ; } } ?>