用的mysql数据库,用下面的sql查出一个list SELECT NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG
from
(
(select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from
(
select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from NOTICE where NOTICE_ORDER is not null AND NOTICE_ORDER<>''
order by NOTICE_ORDER, NOTICE_ID desc) as a
)
union all
(select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from
(
select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from NOTICE where NOTICE_ORDER is null OR NOTICE_ORDER=''
order by NOTICE_ID desc ) as b
)
) as c
LIMIT 0,10
list 页面如下 No Title Order Status Create Time 44 test1 1 Active 2008-06-05
40 test img 1 Active 2008-06-04
37 test order111111 1 Active 2008-06-02
39 test session 2 Active 2008-06-03
26 test123 2 Active 2008-05-30
43 English Active 2008-06-05
我想做的是:点击某个标题,在详细页面里,列出此文章的前一条记录,和后一条记录. 如点击No为39的标题时.. 在详细页显示: 前一条: 37 test order111111
后一条: 26 test123
from
(
(select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from
(
select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from NOTICE where NOTICE_ORDER is not null AND NOTICE_ORDER<>''
order by NOTICE_ORDER, NOTICE_ID desc) as a
)
union all
(select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from
(
select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from NOTICE where NOTICE_ORDER is null OR NOTICE_ORDER=''
order by NOTICE_ID desc ) as b
)
) as c
LIMIT 0,10
list 页面如下 No Title Order Status Create Time 44 test1 1 Active 2008-06-05
40 test img 1 Active 2008-06-04
37 test order111111 1 Active 2008-06-02
39 test session 2 Active 2008-06-03
26 test123 2 Active 2008-05-30
43 English Active 2008-06-05
我想做的是:点击某个标题,在详细页面里,列出此文章的前一条记录,和后一条记录. 如点击No为39的标题时.. 在详细页显示: 前一条: 37 test order111111
后一条: 26 test123
然后在javascript中直接处理.
[align=center]==== 思想重于技巧 ====
[/align]
.
贴子分数<20:对自已的问题不予重视。
贴子大量未结:对别人的回答不予尊重。
.