想寫(xiě)個(gè)統(tǒng)計(jì)用戶上稿排名
{eyou:sql sql=SELECT author COUNT(*) AS count (@rank := @rank + 1) AS rank FROM __PREFIX__archives (SELECT @rank := 0) r WHERE author != 'admin' GROUP BY author ORDER BY count DESC;"}
排名：{$field.rank}
用戶：{field:author}
上稿：{field:count}
{/eyou:sql}
這串sql代碼在sql中都能運(yùn)行，為什么放進(jìn)網(wǎng)站就顯示缺少sql值呢？
