我改成如下

  sprintf(sqlbuf,"select avg(class) ,count(filename) ,board,mid(filename,3,10) as tt,avg(class)*count(filename) as cnt from articlevote group by filename having  cnt>=%d and %ld- tt<%d order by  cnt desc,tt desc " , pingjiacaishu,curtime,jinrishijian );


主要是照ytht的总分说法

现在设定的门限值也是总分>=pingjiacaishu=15


【 在 dgwang.bbs@bbs.qxntc.edu.cn (DG大哥) 的大作中提到: 】
: 我现在的sql改成下面这个样子了，你改成什么样了？
:   sprintf(sqlbuf,"select avg(class),count(filename) as cnt,board,mid(filename,3,10) as tt ,count(filename)*0.6+avg(class)*0.4
:  as zf from articlevote group by filename having  cnt>=%d and %ld- tt<%d order by  zf desc " , pingjiarenshu,curtime,jinrishi
: jian );
: 【 在 wy.bbs@bbs.tju.edu.cn.no.spam (王爷~归来) 的大作中提到: 】
: : 应该是
: ...................
--
FROM bbs.tju.edu.cn