<?php

//设置数据库变量
$db_host   = 'localhost';
$db_user   = 'root';
$db_passw = '123456';
$db_name  = 'freebb';

$conn = mysql_connect($db_host,$db_user,$db_passw) or die ('数据库连接失败！');
mysql_query("set names 'utf8'");

mysql_select_db($db_name,$conn) or die('数据库选定失败！');
$sql = "SELECT * FROM `member` ORDER BY `id` DESC LIMIT 0, 16";

$result = mysql_query($sql) or die('数据库查询失败！');

  while($mem = mysql_fetch_object($result)) //循环开始
{
    $username = $mem->username;
      $bbsname = $mem->bbsname;
    $bbstype = $mem->bbstype;
?>

              <li>
                <div class="title"><a href="http://<?php echo $username; ?>.lingd.cn/" target="_blank"><?php echo $bbsname; ?></a></div>
                <div class="type">[<?php echo $bbstype; ?>]</div>
              </li>

<?php
}
?>