[RESOLVED] Url from MySQL?

[Smeep]

I bet you're all sick of me 😉

I have a URL stored in a database, "portfolio" I need to output this, as a clickable URL.

if ($result = @mysql_query($sql)) {

	 while($row = mysql_fetch_array($result)){
	 echo $row['username'];
	 echo '<br />' . $row['portfolio'];
	 }

What do I have to do to this line

echo '<br />' . $row['portfolio'];

to make it in to a URL when it is echo'd? I tried fiddling with HTML around it, but it's not having it 🙁

Thanks!

[devinemke]

$result = mysql_query($sql) or exit(mysql_error());

while ($row = mysql_fetch_assoc($result))
{
	echo $row['username'] . '<br>' . '<a href="' . $row['portfolio'] . '">' . $row['portfolio'] . '</a><br><br>'; 
}

[Smeep]

That's what I tried... but hey, got it working 😃 thanks 😃