代码:

---

mysql>use phpmod;
mysql>select topic_id,forum_id,topic_title from phpbb_topics where forum_id=2 order by topic_id desc limit 2;

---

引用:

---

+----------+----------+-------------+
| topic_id | forum_id | topic_title |
+----------+----------+-------------+
|        4 |        2 | 测试3      |
|        3 |        2 | 测试2      |
+----------+----------+-------------+
2 rows in set (0.03 sec)

---

代码:

---

<?php
$dbms = 'mysql4';
$dbhost = 'localhost';
$dbname = 'phpmod';
$dbuser = 'root';
$dbpasswd = '123456'; //密码:)
$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

$query = "select topic_id,forum_id,topic_title from phpbb_topics where forum_id=2 order by topic_id desc limit 2";

//连接到mysql服务器
$connection =mysql_connect ($dbhost,$dbuser,$dbpasswd);
//打开$dbname数据库
mysql_select_db($dbname,$connection);

$result = mysql_query($query,$connection);

while ($row = mysql_fetch_array($result))
 echo $row["topic_title"];  

---

引用:

---

测试3测试2

---

代码:

---

echo "{$row["topic_title"]}<br>"; 

---

代码:

---

echo "<a href="http://www.20cn.net"> <?php echo "{$row["topic_title"]}<br>";  ?> </a>"

---

代码:

---

<?php
include 'config.php';
$query = "select topic_id,forum_id,topic_title from phpbb_topics where forum_id=2 order by topic_id desc limit 2";
//连接到mysql服务器
$connection =mysql_connect ($dbhost,$dbuser,$dbpasswd);
//打开$dbname数据库
mysql_select_db($dbname,$connection);
$result = mysql_query($query,$connection);
while ($row = mysql_fetch_array($result))
{
//连接到20cn
echo "<a href=http://www.20cn.net>".$row["topic_title"]."</a><br>";
} 
?>

---