[e:loop={"select classid,classname from {$dbtbpre}enewsclass where classid in(3,2,5,1,4) order by field(classid,2,5,1,4,3) desc",0,24,0}] <?=$bqr[classid]?><br />[/e:loop]原来在mysql中,field(字段名,v1,v2,v3) asc 可以按照对应的字段排序。