[SOLVED] Data in mysql echoed in php as a link

[alconebay]

I have a website field in mysql that I want to echo in a table with php. What happens is my domain automatically gets put in front of the website address being pulled from mysql. Example:

 

<a href="<? echo $web; ?>">Website</a>

 

if "$web" was "www.someothersite.com" the link that displays on the page will be http://www.mywebsite.com/www.someothersite.com

 

How do I get my domain out of the link?

[papaface]

You'd have to correct what ever is causing the problem as it looks like your appending your address to any href attribute. Therefore there is no way to correct it without going to the source - to my knowledge.

[alconebay]

Thanks, I found out that you have to put a "http://" in front of any web site addresses in the database. That fixed my problem.

[redarrow]

no you dont have to do ya what about this then will it work.

<?php

//database connection.

$sql="select * from links";
$result=mysql_query($sql) or die(mysql_error());

while($x=mysql_fetch_assoc($result)){

echo" http://".$x['links']." ";
}
?>