can anyone help me? I'm making a website for my hockey club and want to have player profiles a bit like this : http://www.xkewl.com/bhhhcdynamic/profile.asp - http://www.xkewl.com/bhhhcdynamic/profile.asp , but what i would like is for it to be dynamic and access db driven so i just have to add info to db to add a new player rather than add a whole profile page each time, so i can just add a link like http://www.xkewl.com/bhhhcdynamic/profile.asp?Player=223 - http://www.xkewl.com/bhhhcdynamic/profile.asp?Player=223 the problem is i havent the first idea how to go about it, so any help would be appreciated

p.s. i dont need an admin page, i understand access db (and how to edit etc)

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

i dont suppose you could put a small example code together on here? (includeing the connection to the db etc the db being d:/domains/xkewl.com/private/profiles.mdb

i would realy appreciate it

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
 
 %>