id title time 1 111 2009-02-25 23:51:17 2 55 2009-02-25 23:51:24 3 66 2009-02-25 23:51:37 怎么样做呢 这样吗
我这样写UPDATE daohang SET `time` = NOW( ) WHERE id = '(SELECT id FROM `daohang` ORDER BY `time` ASC LIMIT 0 , 1 )' 为什么不更新 UPDATE daohang SET `time` = NOW( ) WHERE id = (SELECT id FROM `daohang` ORDER BY `time` ASC LIMIT 0 , 1 ) 这样就有错!高手来帮帮忙
用任意方式设置一个访问计数器查询时做如下排序 select * from tbl_name where 查询条件 order by id>计数值, 原有的排序列 ....
SELECT * FROM `daohang` order by id>1 SELECT * FROM `daohang` order by id>2 SELECT * FROM `daohang` order by id>3 查询结果没变
你不用这样写update语句,你的程序应该能得到现在正在访问的人的Id,然后update这样写:"UPDATE daohang SET `time` = NOW( ) WHERE id = '".$id."'"; ¥id就是你现在正在访问的人的ID,
1 111 2009-02-25 23:51:17
2 55 2009-02-25 23:51:24
3 66 2009-02-25 23:51:37 怎么样做呢
这样吗
为什么不更新
UPDATE daohang SET `time` = NOW( ) WHERE id = (SELECT id FROM `daohang` ORDER BY `time` ASC LIMIT 0 , 1 )
这样就有错!高手来帮帮忙
select * from tbl_name where 查询条件 order by id>计数值, 原有的排序列 ....
SELECT * FROM `daohang` order by id>2
SELECT * FROM `daohang` order by id>3
查询结果没变