how to link from recordset display

Hi again, Im stuck once more, this time i want to display on a page, one instance of each (often repetitive) value from a column in a database, so that a user can click on that value and then be processed to go to a specific .htm page that matches that value.
ie.
DB Field name yogibear will appear...
yogibear ... and will link to yogibear.htm

I have been trying to pass id nos but i either get an error or select all the names in a field. I dont know anything about arrays but is this the time i have to learn? Can anyone tell me how i should do this?

you can call the page itself (yogibear.asp (or aspx)) and pass values


by querystring

yogibear.asp?val=10

by session

session("val")=10

by transfer

val=10
server.transfer(yogibear.asp)

and then you get the value as you like to do

SELECT * FROM myTable WHERE ID= val

thanks for the reply , i will try and see if i can get it to do what i want, though i must say i have no idea what im doing or where im going but i suppose ive got his far by knowing nowt so i may as well continue....