ขอสอบถามเกี่ยวกับข้อมูลที่ออกมาแสดงผลอะครับ ที่ดึงออกมาจาก mysql ข้อมูลเป็น varchar ยกตัวอย่างเช่น http://www.thaicreate.com ซึ่งเมื่อจุดๆ ใดเป็น address อยากให้มีลิงค์กดเข้าสู่่เว็บนั้นได้เลยอะครับ รบกวนหน่อยครับ

function autolink($temp)
{
//link email
$temp = preg_replace("#(^|[\n ])([a-z0-9&\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)*[\w]+)#i", "\\1<a href=\"mailto:\\2@\\3\"><font color=#FF6600>\\2@\\3</font></a>", $temp);

//link http://
$temp = preg_replace("#(^|[\n ])([\w]+?://[^ \"\n\r\t<]*)#is", "\\1<a href=\"\\2\" target=\"_blank\"><font color=#FF6600>\\2</font></a>", $temp);

//link www.
$temp = preg_replace("#(^|[\n ])((www|ftp)\.[^ \"\t\n\r<]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\"><font color=#FF6600>\\2</font></a>", $temp);

return ( $temp ) ;
}

<script language="javascript">
function autolink($temp)
{
//link email
$temp = preg_replace("#(^|[\n ])([a-z0-9&\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)*[\w]+)#i", "\\1<a href=\"mailto:\\2@\\3\"><font color=#FF6600>\\2@\\3</font></a>", $temp);

//link http://
$temp = preg_replace("#(^|[\n ])([\w]+?://[^ \"\n\r\t<]*)#is", "\\1<a href=\"\\2\" target=\"_blank\"><font color=#FF6600>\\2</font></a>", $temp);

//link www.
$temp = preg_replace("#(^|[\n ])((www|ftp)\.[^ \"\t\n\r<]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\"><font color=#FF6600>\\2</font></a>", $temp);

return ( $temp ) ;
}
</script>
<?
$temp = $row["nw_detail"];
?>

                <td width="338" align="left" onkeyup="autolink($temp);"><?=$temp; //$row["nw_detail"];?></td>

                <td width="338" align="left" ><?  echo autolink($row["nw_detail"]); ?></td>

<h2>ข่าวใหม่ประจำสัปดาห์</h2>
<div style="width:100%; height:300px; overflow: auto !important; overflow-x: auto; overflow-y: auto;">
  <link href="Calendar_Main/south-street/jquery-ui-1.8.10.custom.css" rel="stylesheet" type="text/css" />
  <?
	include("System_ConnectDB.php");	
	mysql_query("SET NAMES UTF8", $db_connect);
	
	$sql_str = "select * from tbnewsweek order by nw_id desc ";
	
	$db = mysql_select_db("myprdB",$db_connect) or die("ติดต่อฐานข้อมูลไม่ได้");
	$sql_result = mysql_query($sql_str,$db_connect) or die("เอ็กซิคิวต์คำสั่ง SQL ไม่ได้");
?>
  <table width="150" border="0">
      <td width="600"  align="center" valign="top" >
        <div id="accordion">
        <? 	while($row = mysql_fetch_array($sql_result)) { ?>
          <div style="font-size:14px; font:tahoma;"> <?=$row["nw_name"]?></div>
          <div >
            <table width="475" border="0">
              <tr>
                <td width="142" align="left"><!--<img src="Calendar_Main/image/book1.jpg" --> <img src="NewsWeekPhoto/<?=$row["picture"]?>" width="114" height="150" /></td>
                
<?
function autolink($temp)
{
//link email
$temp = preg_replace("#(^|[\n ])([a-z0-9&\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)*[\w]+)#i", "\\1<a href=\"mailto:\\2@\\3\"><font color=#FF6600>\\2@\\3</font></a>", $temp);

//link http://
$temp = preg_replace("#(^|[\n ])([\w]+?://[^ \"\n\r\t<]*)#is", "\\1<a href=\"\\2\" target=\"_blank\"><font color=#FF6600>\\2</font></a>", $temp);

//link www.
$temp = preg_replace("#(^|[\n ])((www|ftp)\.[^ \"\t\n\r<]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\"><font color=#FF6600>\\2</font></a>", $temp);

return ( $temp ) ;
}
?>

                <td width="338" align="left" ><?  echo autolink($row["nw_detail"]); ?></td>
              </tr>
            </table>
          </div>
		  <? } ?>           
        </div>
          
        <script type="text/javascript" src="Calendar_Main/jquery-1.4.4.js"></script>
        <script type="text/javascript" src="Calendar_Main/jquery-ui-1.8.10.custom.js"></script>
        <script  type="text/javascript" >
 $(function(){
$("#accordion").accordion ({autoHeight: "false"});
});
  </script>
   
  </table>

</div>