我又想了个办法,将编号作为副键,新增了字段名为cid的自动increament的主键$result=mysql_query("SELECT max(cid), id, daima, start_time FROM db WHERE id='$id' GROUP BY daima");但是max(cid)好像没有起到作用,因为输出结果还是我主帖的最后一个图...
--测试代码 use SQL_Test go create table ttime( bh varchar(200) not null, sj datetime ) insert into ttime select '2009111601','2009-11-16 15:01:46' union all select '2009111601','2009-11-16 15:02:46' union all select '2009111601','2009-11-16 15:03:46' union all select '2009111601','2009-11-16 15:04:46' union all select '2009111602','2009-11-16 15:05:46' union all select '2009111602','2009-11-16 15:07:46' --查询 select bh,max(sj) from ttime group by bh --结果 2009111601 2009-11-16 15:04:46.000 2009111602 2009-11-16 15:07:46.000
首先请荣我感谢dzxccsu达人的乐意助人精神,太感动了,还建立了表测试... 但是我照着您的例子也做了个一抹一样的测试,居然还是不出时间字段的值...彻底崩溃 <?php $result=mysql_query("SELECT bh, max(sj) FROM ttime GROUP BY bh"); while($row=mysql_fetch_array($result)){ echo $row["bh"]."<br />"; } ?><?php $result=mysql_query("SELECT bh, max(sj) FROM ttime GROUP BY bh"); while($row=mysql_fetch_array($result)){ echo $row["sj"]."<br />"; } ?>
$result=mysql_query("SELECT bh, max(sj) FROM ttime GROUP BY bh"); while($row=mysql_fetch_row($result)){ echo $row[1]." <br />"; 试试
select bh,max(UNIX_TIMESTAMP(sj)) from tt group by bh
但这样处理也有问题因为sj(在我这里既start_time)是echo的内容
如果用了max(start_time)那“最后更新”那一栏就会echo空白,无内容max(daima)也是同样问题
这样一来就有值出现在“最后更新”了,但输出的效果还是我正文最后一贴得效果..
--测试代码
use
SQL_Test
go
create table ttime(
bh varchar(200) not null,
sj datetime
)
insert into ttime
select '2009111601','2009-11-16 15:01:46'
union all
select '2009111601','2009-11-16 15:02:46'
union all
select '2009111601','2009-11-16 15:03:46'
union all
select '2009111601','2009-11-16 15:04:46'
union all
select '2009111602','2009-11-16 15:05:46'
union all
select '2009111602','2009-11-16 15:07:46'
--查询
select bh,max(sj) from ttime group by bh
--结果
2009111601 2009-11-16 15:04:46.000
2009111602 2009-11-16 15:07:46.000
但是我照着您的例子也做了个一抹一样的测试,居然还是不出时间字段的值...彻底崩溃
<?php
$result=mysql_query("SELECT bh, max(sj) FROM ttime GROUP BY bh");
while($row=mysql_fetch_array($result)){
echo $row["bh"]."<br />";
}
?><?php
$result=mysql_query("SELECT bh, max(sj) FROM ttime GROUP BY bh");
while($row=mysql_fetch_array($result)){
echo $row["sj"]."<br />";
}
?>
$result=mysql_query("SELECT bh, max(sj) FROM ttime GROUP BY bh");
while($row=mysql_fetch_row($result)){
echo $row[1]." <br />";
试试
太神奇了,究竟是什么原因呢?以前echo['关键字']都可以的,为何这次必须用1呢?
$result=mysql_query("SELECT bh, max(sj) as sj FROM ttime GROUP BY bh");
while($row=mysql_fetch_array($result)){
echo $row["sj"]." <br />";
}
这样也行
叩谢dzxccsu达人!