please help me with this school project for an e-commerce site that im doing ryt now..im a newbie in programming..
here s the scenario..
Im using coldfusion,ms access,dwcs3
How can I dynamically view the products that are base on dynamic category and subcategory?
using URL parameters
我在座谈一下我的座谈。
tblcategory fieldname datatype category text subcategory text tblproduct ProductID text Subcategory text enter code here Description text
我已经生动地展示了这一类和子类,但我无法找到一种解决办法,显示其类别和子类的产品基础。
我的法典
<cfparam name="URL.Category" default="1">
<cfquery name="rs_category" datasource="Database">
SELECT DISTINCT category
FROM tblcategory
</cfquery>
<cfquery name="rs_subcategory" datasource="Database">
<cfif category eq 1>
SELECT *
FROM tblcategory
<cfelse>
SELECT *
FROM tblcategory
WHERE Category = <cfqueryparam value="#URL.Category#" cfsqltype="cf_sql_clob" maxlength="50">
</cfif>
</cfquery>
<body>
<cfoutput query="rs_category"><a href="dynamic.cfm?category=#rs_category.category#">#rs_category.category#</a><br />
</cfoutput>
<br />
<cfoutput query="rs_subcategory">#rs_subcategory.Subcategory#<br />
</cfoutput>
<br />
</body>
</html>
样本
category(dynamic category) Electrical (when click show electrical subcategory) Steel Wood subcategory(base on the category dynamically show the subcategory) Phelps dodge Metro Wire
Wire Spool
(我需要动态显示属于同一类别和亚类的产品)
(这是我需要知道的那部分,这样就能够帮助我。)