mysql data into url

scatchon

im pulling rows of data from mysql and showing it on screen using php. One field for each record is a URL. I was wondering if there was a way to code it so that it actually became an active a href that people can click on.

here's a bit of the code.

echo "<br>";
echo $row['website'];
echo "<br>";

'website' shows the domain data from mysql

i was thinking something like

echo "<a href= xxxxx

prior to the $row['website']; and closing the a tag after that line but I dont know the code.

thanks in advance!

onion2k

Originally posted by scatchon
echo "<br>";
echo $row['website'];
echo "<br>";

echo "<br>";
echo "<a href=\"".$row['website']."\">".$row['website']."</a>";
echo "<br>";

It really is that easy..

kingbear


echo "<br>";
echo "<a href=\"" . $row['website']. "\">" . $row['website'] . "</a>";
echo "<br>";

scatchon

For some reason the URL's , which are offsite, have my sites domain in them.

for example:

the link should be - http://www.argents.com

but it is coming out as - http://scwtc.org/www.argents.com

scwtc.org is the site that this script is sitting on. it shouldn't be included in the url.

and thanks for the speedy replies!!

Roger_Ramjet

This is how I code it.


echo '<table border="1" cellspacing="0" cellpadding="3">';
echo '<tr><th>website</th><th>' . $client . ' ref</th><th>name</th></tr>';
	// Iterate through the results
	while ($row = mysql_fetch_array($result)) {
		$link = '<a href="' . $row['url'] . '">';
		echo '<tr><td>' . $link . $row['url'] . '</a></td>';
		echo '<td>' . $link . $row['ref'] . '</a></td>';
		echo '<td>' . $link . $row['name'] . '</a></td>';
	}
echo '</table>';

onion2k

Originally posted by scatchon
for example:

the link should be - http://www.argents.com

but it is coming out as - http://scwtc.org/www.argents.com

You need to make sure the links in the database start with [url]http://[/url] ..

scatchon

therein lies a problem - the database url's have no [url]http://[/url] before any of them and there are a ton of them

Roger_Ramjet

 $url = $row['url'];
 if (substr($url, 0, 7) !== 'http://') {
     $url = 'http://' . $url
{

 $link = '<a href="' . $url . '">';