[SOLVED] Making emails and URLs from database records linkable

[86Stang]

The records I'm displaying typically have either an email address or URL listed in the text somewhere.  I'm curious if making them a link while being displayed is a big challenge?

[jelly]

<?php

function transform2link($row)
{
	$row = ereg_replace("([0-9a-zA-Z]([-_.\w]*[0-9a-zA-Z_])*@(([0-9a-zA-Z])+([-\w]*[0-9a-zA-Z])*\.)+[a-zA-Z]{2,9})", "<a href=\"mailto:\\0\">\\0</a>", $row);
	$row = ereg_replace("[a-zA-Z]+://([.]?[a-zA-Z0-9_/-])*", "<a href=\"\\0\">\\0</a>", $row);
	$row = ereg_replace("(^| )(www([.]?[a-zA-Z0-9_/-])*)", "\\1<a href=\"http://\\2\">\\2</a>", $row);

	return $row;
}

$sql_query = "SELECT * FROM `table`";
$sql = mysql_query($sql_query) OR die(mysql_error());

	while($r = mysql_fetch_array($sql))
	{
		echo transform2link($r['your_row']);
	}

?>

 

--

jelly

[86Stang]

Woohoo!  Worked like a champ!  Thanks!