嗯,没有这条Key的定义的时候,页面有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
直接找相应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
加上这条定义就没事了,hehe...-_-
【 在 dvlt (饿了就要吃!) 的大作中提到: 】
: 应该不搭界啊。
--
FROM 221.192.220.*