<?php require ("bbs/config.inc.php"); //连接,选择数据库 $link = mysql_connect( $dbhost,$dbuser,$dbpw) or die("Could not connect:".mysql_error()); mysql_select_db($dbname) or die("Could not elect database");
$fid=$_GET["fid"]; //截取字符长度 $length=36; //防止中文乱码 mysql_query("set names "gb2312""); //执行SQL查询 $query = "SELECT tid,subject FROM cdb_threads where fid="$fid" order by lastpost desc LIMIT 10"; $result = mysql_query($query) or die("Query failed: ".mysql_error()); // 用 HTML显示结果 while ($myrow = mysql_fetch_row($result)) { printf("document.writeln("<li><a href=\"bbs/viewthread.php?tid=%s&extra=page=1\ " target=\"_blank\">%s</a></li>");
", $myrow[0],cutstr($myrow[1], $length,"..")); } // 释放结果集 mysql_free_result($result); //关闭连接 mysql_close($link);