creating a link

[bookouri]

I know this has to be simple.

I construct a table from my database

Name Address Phone
Smith, John 111 first st 888-8888
etc etc


I want to hyperlink the name in the table so the user can click on the name and pull up a photo of the employee.

How can I construct something like that in asp?

any help would be appreciated

 

[vasah20]

while not rs.eof
Response.write &quot;<a href=showpic.asp?name=&quot; & server.urlencode(rs(&quot;name&quot) & &quot;>&quot; & rs(&quot;name&quot & &quot;</a><br>&quot;
rs.movenext
wend

assuming that name is the column of names in your recordset leo