converting text to hyperlink in php

[runway27]

i need to insert a hyperlink to an sql query. there is a field in the table called url which consists of the url of a page, i would like this information to be displayed as a hyperlink so that i can click on the link.

following is the code =

$sql = " SELECT Count(*) .....";
$rs_newEnquiries = mysql_query($sql, $connEnquiry);

$echoStr = "<table width='80%' cellpadding=1 cellspacing=1 border=0><tr bgcolor='#cccccc;'><th bgcolor='#cccccc' width=10>Count</th><th bgcolor='#cccccc' width=400>Url</th></table>";
while ($row_rs_newEnquiries = mysql_fetch_assoc($rs_newEnquiries))
{
$echoStr .= " <tr bgcolor='#ebebeb' class='default'> <td> ".$row_rs_newEnquiries['url']."</td>
}

please advice how i can convert this information that is being displayed into a hyperlink.

thanks.

[rpnew]

i need to insert a hyperlink to an sql query. there is a field in the table called url which consists of the url of a page, i would like this information to be displayed as a hyperlink so that i can click on the link.

following is the code =

$sql = " SELECT Count(*) .....";
$rs_newEnquiries = mysql_query($sql, $connEnquiry);

$echoStr = "<table width='80%' cellpadding=1 cellspacing=1 border=0><tr bgcolor='#cccccc;'><th bgcolor='#cccccc' width=10>Count</th><th bgcolor='#cccccc' width=400>Url</th></table>";
while ($row_rs_newEnquiries = mysql_fetch_assoc($rs_newEnquiries))
{
$echoStr .= " <tr bgcolor='#ebebeb' class='default'> <td> ".$row_rs_newEnquiries['url']."</td>
}

please advice how i can convert this information that is being displayed into a hyperlink.

thanks.

Hi,
I think you need to just add <A> tag in your code... like following..
[PHP]
$echoStr .= " <tr bgcolor='#ebebeb' class='default'> <td><A> ".$row_rs_newEnquiries['url']."</A></td>
[/PHP]