dengrenfu
新手上路
UID 120797
精华
0
积分 3
帖子 1
金钱 3 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2008-4-29
来自 永州
状态 离线
|
[广告]: q
m
急求求大家帮忙-数据库个人信息出错代码如下！
急求求大家帮忙-数据库个人信息出错代码如下！
Discuz! info: MySQL Query Error
dengrenfu189@163.com
User: dengrenfu
Time: 2008-4-29 1:34pm
Script: /bbs/space.php
SQL: SELECT m.*, mf.*, u.grouptitle, u.type, u.creditshigher, u.creditslower, u.readaccess,
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol, p.*
FROM [Table]members m
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
LEFT JOIN [Table]usergroups u ON u.groupid=m.groupid
LEFT JOIN [Table]ranks r ON m.posts>=r.postshigher
LEFT JOIN [Table]pig p ON p.userb=m.username
g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.postshigher DESC LIMIT 1
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 'g LEFT JOIN [Table]onlinetime o ON o.uid=m.uid
WHERE m.uid='49616'ORDER BY r.po' at line 9
Errno.: 1064
Similar error report has beed dispatched to administrator before.
如果有谁知道？
加我QQ：289625925与我联系！谢谢大家！
|
|
