Discuz! info: MySQL Query Error
User: 傳說V炎帝
Time: 2007-7-24 1:49pm
Script: /star.php
SQL: SELECT count(p.pid) as num,p.author,p.authorid,m.uid,m.credits,m.posts,m.digestposts ,m.oltime
FROM [Table]posts p left join [Table]members m on p.authorid=m.uid WHERE p.dateline>= and p.dateline< group by p.authorid order by num desc limit 0,10
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 'and p.dateline< group by p.authorid order by num desc limit 0,10' at line 2
Errno.: 1064
Similar error report has beed dispatched to administrator before. |
显身卡