Side bar category that opens up when clicked

[James]

I'm trying to develop a suitable navigation structure for
my website, but I've gotten stumped trying to develop the
navigation. I would like a side bar that list the
categories then once a user clicks a category then it
opens the pages within the category. Here is a link to
what I want to accomplish.

[url]http://demo.acuitycms.com/[/url]

When you click on products and services, it opens up the
products and services.

My database schema:

category
catid int identity
catTitle varchar(50)

page
pageID INT identity
catID int references category(catID)
pageTitle varchar(50)
pageBody text

Thanks and any insight would be appreciated.

[James]

OK, I think I figured it out. Can this code be
optimized. What I am doing is checking if the categoryID
from the request("categoryID") is <> "" then If it is I
then run the code to display the pages within that
category. Is there a better way to so I won't have to
check, seems like I could use a join or something. Any
insight let me know.

************ code start ********************
<div id="links">
<%
CategoryID = trim(request("categoryID"))
%>
<ul>
<%
' gets the links for the menu
sql = "select catID, catTitle from category order by
catID"
set rs = Conn.execute(sql)
do while not rs.eof %>
<li>
<a href="template.asp?CategoryID=<%=rs("CatID")%>"><% =rs
("catTitle")%></a>
</li>
<%
if cint(rs("catID")) = cint(categoryID) then
sql2 = "select catID, conID, pageTitle from content where
catID = " & CategoryID & " order by catID"
set rs2 = ADODBConn.execute(sql2)

do while not rs2.eof %>
<li class="test">
<a href="template.asp?CategoryID=<%=rs2
("CatID")%>">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%=r s2
("catTitle")%></a>
</li><%
rs2.movenext
loop
end if
%>
<%
rs.movenext
loop
%>
</ul>
</div>
************ code end ********************

>-----Original Message-----
>I'm trying to develop a suitable navigation structure for
>my website, but I've gotten stumped trying to develop the
>navigation. I would like a side bar that list the
>categories then once a user clicks a category then it
>opens the pages within the category. Here is a link to
>what I want to accomplish.
>
>[url]http://demo.acuitycms.com/[/url]
>
>When you click on products and services, it opens up the
>products and services.
>
>My database schema:
>
>category
>catid int identity
>catTitle varchar(50)
>
>page
>pageID INT identity
>catID int references category(catID)
>pageTitle varchar(50)
>pageBody text
>
>Thanks and any insight would be appreciated.
>
>
>.
>