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
答案:$row[tid]问题,一是大小写不对,二是这样写tid会被当做一个常量变量。最好完整写成$row['Tid']
上一个:学会了php再去学c++之类的语言困难么?
下一个:高分请教一个php正则替换写法.按开头,结尾,中间不限替换.