直接找出相应sql语句在mysql里查询
mysql> SELECT nodes.uid , nid , subject
-> FROM nodes use index(visitcount) ,users
-> WHERE access = 0
-> AND nodes.uid = users.uid
-> AND nodetype = 0
-> AND pctype < 4
-> GROUP BY uid
-> ORDER BY nodes.visitcount DESC
-> LIMIT 0 ,10;
ERROR 1072: Key column 'visitcount' doesn't exist in table
最后的错误信息不是太明白,没创建什么么?
【 在 roctall (蛇王阿奔) 的大作中提到: 】
: ft...
: 对了,现在“最热日志”这里出现了Warning
: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/bbs/kbs_bbs/bbs2www/html/pc/pcstat.php on line 327
: ...................
--
FROM 221.192.220.*