ใครรู้โค๊ดเอาหัวข้อจากPHPBB Board Forum มาแสดงหน้าแรกindex ของเว็บ
Tag : - - - -
Date :
17 ม.ค. 2550 01:30:21
By :
kim_rbac
View :
2044
Reply :
1
No. 1
Guest
<?
include("../forum/config.php");
$conn = mysql_connect($dbhost ,$dbuser,$dbpasswd) or die ("ติดต่อฐานข้อมูลไม่ได้");
mysql_select_db($dbname) or die ("เลือกฐานข้อมูลไม่ได้");
$strSQL1 = "SELECT topic_id, forum_id, topic_title, topic_poster FROM hrd_topics where forum_id ='1' order by topic_id DESC LIMIT 10";
$result = mysql_query($strSQL1,$conn);
$i=1;
while ($row = mysql_fetch_array($result)){
$topic_id = $row['topic_id'];
$forum_id = $row['forum_id'];
$topic_title = $row['topic_title'];
$topic_poster = $row['topic_poster'];
$strSQL2 = "SELECT username FROM hrd_users WHERE user_id='$topic_poster' ";
$result2 = mysql_query($strSQL2,$conn);
$row2 = mysql_fetch_array($result2);
$tmp_user = $row2['username'];
Load balance : Server 01
