By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,162 Members | 1,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,162 IT Pros & Developers. It's quick & easy.

building menu with loops on asp?

100+
P: 347
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

Expand|Select|Wrap|Line Numbers
  1. <div id="artistnav">
  2.  
  3. <% Do until (sectionsRecordset.EOF) %>
  4.  
  5. <span class="navlabel <%= sectionsRecordset("sectionstxt") %>label"><img src="http://bytes.com/submit/images/artistnav/<%= sectionsRecordset("sectionstxt") %>.png" width="150px" height="150px">
  6.  <span class="texttotop">
  7.  
  8.  <% Do until (vtypeRecordset.EOF) %>
  9.  
  10.  <% if vtypeRecordset("type") = sectionsRecordset("celebstypes") then %>
  11. <a href="boys2.asp?id=<% Response.Write (actorid) %>&voicetype=<%=vtypeRecordset("celebstypes")%>" style="text-transform:capitalize"><%=vtypeRecordset("voicetypetxt")%></a>&nbsp;&nbsp;
  12.  
  13. <% vtypeRecordset.MoveNext %>
  14.  
  15. <a href="boys2.asp?id=<% Response.Write (actorid) %>&voicetype=<%=vtypeRecordset("celebstypes")%>" style="text-transform:capitalize"><%=vtypeRecordset("voicetypetxt")%></a><BR>
  16.           <% else %>
  17.  
  18.           <% end if %>
  19.           <% vtypeRecordset.MoveNext %>
  20.  
  21.           <% Loop %>
  22.           </span></span>
  23.  
  24.           <% vtypeRecordset.MoveFirst %>
  25.  
  26.  
  27.  <% sectionsRecordset.MoveNext %>
  28.   <% Loop %> 
  29.   <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>
  30.   </div>
page can be seen here

http://www.yaketyyakallmouth.com/flu...&voicetype=All

just need to figure out how to loop through 2 recordsets with another loop i think!!!

any help would be appreciated
Aug 9 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.