本主题共有 4 条回复 | 回到顶部
#2 - 2008-6-28 01:51
aquino
Sputnik 1
我去掉了AND mf.hits >100 這段代碼，老是是出現
====================================================
Time: 2008-6-28 1:47am
Script: /bbs/index.php
SQL: SELECT m.uid,m.username,m.usr_geo,mf.nickname,mf.avatar from [Table]members m LEFT JOIN [Table]memberfields mf ON m.uid=mf.uid WHERE mf.avatar != >'100. ORDER BY rand() LIMIT 20
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>'100. ORDER BY rand() LIMIT 20' at line 1
Errno.: 1064
Similar error report has beed dispatched to administrator before.
====================================================
Time: 2008-6-28 1:47am
Script: /bbs/index.php
SQL: SELECT m.uid,m.username,m.usr_geo,mf.nickname,mf.avatar from [Table]members m LEFT JOIN [Table]memberfields mf ON m.uid=mf.uid WHERE mf.avatar != >'100. ORDER BY rand() LIMIT 20
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>'100. ORDER BY rand() LIMIT 20' at line 1
Errno.: 1064
Similar error report has beed dispatched to administrator before.
就少拿掉".AVATAR_SHOW_HITS."這句，正確應該要拿掉
在回复之前你需要先进行登录