Hey guys i am creating a depth charts page for a fantasy football website. The information is pulling from a database in mysql. I have hte abbreviations pulling to the site in link format but i want to know how to make them when clicked display the other information that goes with their abbreviation .. for example when you click ARZ it shows you Arizona Cardinals and hte players on that team right underneath it. Here is the code i have so far which displays the abbreviations in links.
<%
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=MSDASQL; DRIVER=MySQL ODBC 3.51 Driver; SERVER=localhost; DATABASE=ffb; UID=****; PASSWORD=****; OPTION=3"
MySQL = "Select nfl_team_id,nfl_team_abbreviation,nfl_team_city,nfl_team_name from tbl_site_ff_nfl_team"
Set rs = conn.Execute(MySQL)
%>
<div class="textdivision">
<div style="margin-top:10px; margin-left:10px;">
<% while not rs.EOF
Response.Write("<a href=depthcharts.asp?teamid=" & rs.Fields(0) & ">" & rs.Fields(1).Value & "</a>")
Response.Write(" " & "|" & " ")
rs.MoveNext
wend
%>
<%
rs.close
conn.close
%>
</div>
</div>
thanks, eric
<%
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=MSDASQL; DRIVER=MySQL ODBC 3.51 Driver; SERVER=localhost; DATABASE=ffb; UID=****; PASSWORD=****; OPTION=3"
MySQL = "Select nfl_team_id,nfl_team_abbreviation,nfl_team_city,nfl_team_name from tbl_site_ff_nfl_team"
Set rs = conn.Execute(MySQL)
%>
<div class="textdivision">
<div style="margin-top:10px; margin-left:10px;">
<% while not rs.EOF
Response.Write("<a href=depthcharts.asp?teamid=" & rs.Fields(0) & ">" & rs.Fields(1).Value & "</a>")
Response.Write(" " & "|" & " ")
rs.MoveNext
wend
%>
<%
rs.close
conn.close
%>
</div>
</div>
thanks, eric