当前位置:编程学习 > php >>

PHP显示全部数据

SQL语句 select Tid, bbs_forum_thread.subject from (select subject,min(dateline) as mindateline from bbs_forum_thread group by subject having count(*)>1) maxdate, bbs_forum_thread where maxdate.subject=bbs_forum_thread.subject and mindateline=bbs_forum_thread.dateline order by TID 显示2个tid和一个subject 就是 <tr align=center><td><input name=tidarray[] type=checkbox value=tid checked></td><td>tid]</td><td>subject</td></tr>
补充:<?php
$tid=mysql_query("select Tid, bbs_forum_thread.subject from (select subject,min(dateline) as mindateline from bbs_forum_thread group by subject having count(*)>1) maxdate, bbs_forum_thread where maxdate.subject=bbs_forum_thread.subject and mindateline=bbs_forum_thread.dateline order by TID");
while($rows=mysql_fetch_array($tid)){
?>
<tr align=""center""><td><input name=""tidarray[]"" type=""checkbox"" value="<?php echo $row[tid]?>" checked></td><td><?php echo $row[tid]?></td><td><?php echo $rows[subject]?></td></tr>
<?php }?>
这段有什么不对吗? 为什么不显示tid?是不是SQL语句有问题?MYSQL
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,