21,882
社区成员
发帖
与我相关
我的任务
分享
$sql = "select fid,name from cdb_forums where fup = 9";
$result = mysql_query($sql);
while($rs = mysql_fetch_assoc($result))
{
$sql2 = "select tid,subject from cdb_threads where fid = '".$rs['fid']."' order by tid desc limit 0,1";
$result2 = mysql_query($sql2);
while($rs2 = mysql_fetch_assoc($result2))
{
echo $rs2['tid'].'<br>';
echo $rs2['subject'].'<br>';
}
}
select F.fid as fid, F.name as name, T.tid as tid, T.subject as subject
from cdb_forums F join cdb_threads T on F.fup = T.fid
where F.fup = 9
order by T.tid desc