|
唉 又遇到一个问题 ... 发表于 2008-5-4 12:15 ... 10687 次点击
我的Mysql是4.x 版本的
Time: 2008-5-4 12:12pm
Script: /bbs/parasy_geo.php
SQL: SELECT t.subject, t.authorid,t.author,t.tid, t.lastpost, mf.uid, mf.avatar FROM [Table]members m, [Table]threads t LEFT JOIN [Table]forums f ON f.fid=t.fid LEFT JOIN [Table]memberfields mf ON mf.uid=t.authorid WHERE m.uid = t.authorid AND m.uid IN (SELECT uid FROM [Table]members WHERE usr_geo IN ('sputnik1')) ORDER BY t.lastpost DESC LIMIT 25
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 'SELECT uid FROM [Table]members WHERE usr_geo IN ('sputnik1')) ORDE
Errno.: 1064
|
|