kinway


disconnected
主题工具

唉 又遇到一个问题

... 发表于 2008-5-4 12:15  ... 10690 次点击

我的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

本主题共有 2 条回复 | 回到顶部
#1 - 2008-5-4 12:40
Sai 桂林
貌似低版本不支持这样的查询?4.1以上还是?
#2 - 2008-5-4 22:33
kinway 武汉
4.0.27
看完之后有话想说?那就帮楼主加盖一层吧!

在回复之前你需要先进行登录
用户名 / UID
密码
Project Parasynthesis | Based on Discuz! 5.5.0 | Thanks to Livid
About | Help | Developer | N2Design
清除 Cookies - 联系我们 - 无名杂志 - Archiver - Mobile
Processed in 0.056088 second(s), 8 queries, Gzip enabled