Hi all,
my website is progressing and i've got data on display pulled in from a SQL server DB.
What I would like to do now is have the links to other sites that are displayed in a table on the left of the page pulled in from the database also. Displaying the link (say www.imdb.com) is no problem but how do I get the link to work ? I have created a table with the fields

ID

Type (numerical to seperate say film links from humour links)

Link (The text they will see, say for IMDB it will say 'Movie Database')

URL (This is the actual code.. which could be <A HREF="http://www.imdb.com"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Movie database</font></A><BR>

how does the URL field tie in as the code for the page ?

I'm using DWMX to create this page.

Thanks in advance,
Mitch....

<a href="<%= Recordset.Fields.Item("URL").Value %>"><%= Recordset.Fields.Item("Link").Value %></a>

Havn't coded in ASP for a long while (been on ASP.NET) so not so sure of the object structure.