building menu with loops on asp?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • colinod
    Contributor
    • Nov 2007
    • 347

    building menu with loops on asp?

    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

    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>&nbsp;&nbsp;
    
    <% 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>
    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
Working...