Outputting links from MySQL

Valord

I am trying to use php to build links from text inserted into a mysql database. The text is inserted into two values, sitename and address. I am using the following code to try and build the link:

<?
$result = mysql_query("SELECT * FROM $show",$connection);
while($myrow = mysql_fetch_array($result)){
print "<A href = \"";
print $myrow['hyperlink'];
print "\">";
print $myrow['sitename'];
print "</a>";
print "<BR>";}
?>

It half works. It shows the link with sitename, but for some reason, it puts my domain right before the site url. Basically, it outputs a blank link. I can't seem to figure out why this is. Any help would be appreciated. Thanks

Todd

nnichols

That is because your browser thinks it is a relative URL. Just add the [url]http://[/url] in front and it should be ok -

<? 
$result = mysql_query("SELECT * FROM $show",$connection); 
while($myrow = mysql_fetch_array($result)){ 
print "<A href = \"http://"; 
print $myrow['hyperlink']; 
print "\">"; 
print $myrow['sitename']; 
print "</a>"; 
print "<BR>";} 
?>

Of course, this depends on the format of the hyperlink when it is stored in the db.

Hope this helps

Valord

Thanks for the suggestion.

Unfortunately, the problem still exists.

The link shows up, but its address is "http://www.mydomain.com/www.correctdomain.com"

It almost seems to me that the loop is executing one time more than I want, and printing a blank url which just becomes the home domain. I could be way off though.

Thanks for your reply though.

Todd

nnichols

<? 
$result = mysql_query("SELECT * FROM $show",$connection); 
while($myrow = mysql_fetch_array($result)){ 
echo '<a href="http://' . $myrow['hyperlink'] . '">' . $myrow['sitename'] . "</a><br>\n"; 
} 
?>

Try this. If you get the same problem post two lines of the source code produced.

Valord

That did the trick. Thanks for your help.

Atvar