dynamic profiles

Make your table with those information, and put a field with an autonumber (the key), let's say, PlayerID.

Then you make your query looking for that Player,

Something like this:

first you get the ID from your querystring:

lngPlayer = CLng(Request.QueryString("Player"))

Then you take the info from the DB.

"SELECT yourtable.* FROM yourtable WHERE yourtable.PlayerID = " & lngPlayer & ""

And your links will look like the one you post above to the profile page with ?Player=223 after the .asp

didn't you say you knew the access db stuff?

This is part of what I use in my news, take a look and adapt, don't forget to put your variables (the Dim stuff) and close the connections and recordsets after you use them.

And you should take a look in the DB tutorials in this site, there's where I learn this. It's more than worth the time you will spend.

<%

Set notiCon = Server.CreateObject("ADODB.Connection")

atarCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("../private/profiles.mdb") <- this is the path from the root, add more ../ for each folder level your app is in, if not in the root.

notiCon.Open atarCon

%>

<%

Dim rsNews  
Dim lngIDNews 

lngIDNews = CLng(Request.QueryString("NewsID"))
 

Set rsNews = Server.CreateObject("ADODB.Recordset")
 
qtrSQL = "SELECT tblNotic.* FROM tblNotic WHERE tblNotic.News_ID = " & lngIDNews & ""
 
rsNews.Open qtrSQL, atarCon
 
 %>