从mysql中提取链接并使其可点击？

Question

I have a database table that stores URL.What I need is grab those URL's from table and make it click-able with the URL's title as anchor.

This is what I have tried:

while($row4 = mysql_fetch_assoc($result4))
{
   echo "<a href =\"$row4[Url1]\">".$row4['Title1']. "</a>";
}

It displays for example my tilte1 that is youtube and Url1 is www.youtube.com.

But when I click on it it is going to localhost/mysite/www.youtube.com

How can I fix this?

Answer 1

Add http:// in front of the link. Then it will go to where you wanted.