喜悦国际村 - 数据库技术 - 急求求大家帮忙-数据库个人信息出错代码如下！(页 1)

喜悦国际村 » 数据库技术 » 急求求大家帮忙-数据库个人信息出错代码如下！

页: [1]

dengrenfu

2008-4-29 01:06 PM

急求求大家帮忙-数据库个人信息出错代码如下！

急求求大家帮忙-数据库个人信息出错代码如下！
Discuz! info: MySQL Query Error
[email]dengrenfu189@163.com[/email]
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与我联系！谢谢大家！

查看完整版本: 急求求大家帮忙-数据库个人信息出错代码如下！