How to store a web address as an active

[Anon]

Hi,
I am just getting started with PHP. I have created a HTML form for people to store their club details in a MYSQL database.

Everything works fine except I would like to display the club web page address as an active link when the search results are displayed.
I know that if If I input the field as:
<a href=\"http://www.kenfighill.com\">http://www.kenfighill.com</a>
and then store that in the database....when the seatch results are displayed the link is active........ how can I automate this???

Thanks

[Anon]

How are you storing the url now? as "http://wwww.kenfighill.com"?

P.O.P

$result=mysql_fetch_array(...)
$url=$result['url]

echo "<a href=\"$url\">$url</a>";

If that's not what you mean, perhaps you could explain better.

[Anon]

Thank you very much for your help..... that was exactly what I needed to point me in the right direction.

Thanks again
Neil