I am building a menu that gets info from my DB and want ti to list in 2 columns, i can get this to work with the following code but it fils when there is only 1 catagory in DB
page can be seen here
just need to figure out how to loop through 2 recordsets with another loop i think!!!
any help would be appreciated
Code:
<div id="artistnav">
<% Do until (sectionsRecordset.EOF) %>
<span class="navlabel <%= sectionsRecordset("sectionstxt") %>label"><img src="http://bytes.com/submit/images/artistnav/<%= sectionsRecordset("sectionstxt") %>.png" width="150px" height="150px">
<span class="texttotop">
<% Do until (vtypeRecordset.EOF) %>
<% if vtypeRecordset("type") = sectionsRecordset("celebstypes") then %>
<a href="boys2.asp?id=<% Response.Write (actorid) %>&voicetype=<%=vtypeRecordset("celebstypes")%>" style="text-transform:capitalize"><%=vtypeRecordset("voicetypetxt")%></a>
<% vtypeRecordset.MoveNext %>
<a href="boys2.asp?id=<% Response.Write (actorid) %>&voicetype=<%=vtypeRecordset("celebstypes")%>" style="text-transform:capitalize"><%=vtypeRecordset("voicetypetxt")%></a><BR>
<% else %>
<% end if %>
<% vtypeRecordset.MoveNext %>
<% Loop %>
</span></span>
<% vtypeRecordset.MoveFirst %>
<% sectionsRecordset.MoveNext %>
<% Loop %>
<a href="boys2.asp?id=<% Response.Write (actorid) %>&voicetype=All" class="navlabel mainlabel"><img src="http://bytes.com/submit/images/artistnav/main.png" width="150px" height="150px"></a>
</div>
just need to figure out how to loop through 2 recordsets with another loop i think!!!
any help would be appreciated