hyperlink in a database

[realtwix]

I'm new at this. How do I create a hyperlink in a database. I'm using Access and Visual Web Developer.

Thanks!

[physics]

Hi realtwix and Welcome to WebmasterWorld.com! [webmasterworld.com]

Typically a database just stores the URL and the text of the url. So you might have a table to hold urls with three fields: id, url and url_text. Then when the data is displayed (on a web page using ASP for example) it is made into a hyperlink by adding the appropriate markup: <a href="$url">$url_text</a> where $url and $url_text represent the data pulled from the database.

[realtwix]

Where do I put this markup?

<a href="$url">$url_text</a>

Like I said very new. Sorry.

[ZydoSEO]

In the HTML for your web page(s) where you want to reference/show a link to the URL you stored in the DB...

[realtwix]

What if the data that shows is only what the user chooses. For instance,On the "search" page, they choose "Tampa" from a dropdown list and then it will display only the properties that are in Tampa. It makes sense for me to add the links to a page if all of the properties were to show up, but how do I know what they will choose? Should I add a link for every property on the search page so that it doesn't matter what they choose?

Thank you so much for taking the time to help me! I really appreciate it!

[realtwix]

Ok . . .I think it just clicked! I'm going to work on this and see what turns out.