需要用到兩個表 1.PE_infos 表 這個表有兩個字段要用到 ModuleType=1即表示文章頻道 ItemID即相應的ArticleID。 2.PE_Special 表 通過SpecialID跟PE_infos的SpecialID關聯 SpecialName為專題名。 具體的sql語句可以設置如下。 select S.* from PE_Special S , PE_Infos I Where I.ItemID ={input(0)} and I.ModuleType=1 and S.SpecialID=I.SpecialID 傳入的參數是ArticleID 具體添加標簽的方法如下
請選擇一個表 PE_Advertisement PE_AdZone PE_Announce PE_AreaCollection PE_Article PE_Author PE_Bank PE_BankrollItem PE_Card PE_Channel PE_City PE_Class PE_Classroom PE_Client PE_Comment PE_Company PE_ComplainItem PE_ConsumeLog PE_Contacter PE_CopyFrom PE_Country PE_DeliverCharge PE_DeliverItem PE_DeliverType PE_Dictionary PE_DownError PE_DownServer PE_Equipment PE_Favorite PE_Field PE_Filters PE_Friend PE_FriendSite PE_FsKind PE_GuestBook PE_GuestKind PE_HistrolyNews PE_HouseArea PE_HouseConfig PE_HouseCS PE_HouseCZ PE_HouseHZ PE_HouseQG PE_HouseQZ PE_InfoS PE_InvoiceItem PE_Item PE_JobCategory PE_JsFile PE_KeyLink PE_Label PE_Log PE_Message PE_NewKeys PE_NotDown PE_OrderForm PE_OrderFormItem PE_Page PE_PageClass PE_Payment PE_PaymentType PE_Photo PE_Position PE_PositionSupplyInfo PE_PresentProject PE_Producer PE_Product PE_Province PE_RechargeLog PE_Resume PE_ServiceItem PE_ShoppingCarts PE_Skin PE_Soft PE_Space PE_SpaceBook PE_SpaceComment PE_SpaceDiary PE_SpaceKind PE_SpaceLink PE_SpaceMusic PE_SpacePhoto PE_SpaceVisitor PE_Special PE_SubCompany PE_Supply PE_Supply_Company PE_Survey PE_SurveyAnswer PE_SurveyInput PE_SurveyQuestion PE_SurveyRecord PE_Template PE_TemplateProject PE_Trademark PE_TransferItem PE_UsedDetail PE_User PE_UserGroup PE_Vote PE_WorkPlace
查看更多 動易Cms教程 動易Cms模板
來源:模板無憂 /
/所屬分類:動易Cms教程 /
更新時間:2007-09-25
相關動易Cms教程 :