HI,
Please make a correction on the 3rd line of your sql string in the index.php. we should not use the special word "mod" . you should change this to something else such as "jod" or some other meaningful word. Following is the corrected sql string which I used.
------
$sql = <<<EOS
SELECT f.id as id, f.forum_name as forum,
f.forum_desc as description,
count(forum_id) as threads, u.name as
jod
FROM forum_forum f
LEFT JOIN forum_posts p
ON f.id = p.forum_id
AND p.topic_id=0
LEFT JOIN forum_users u
ON f.forum_moderator = u.id
GROUP BY f.id
EOS;
--------
Hope this will help to everyone who get this same error..
Linus
Quote:
quote:Originally posted by ambo
me also got the same problem.
The error is something like this
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 'mod FROM forum_forum f LEFT JOIN forum_posts p ON f.id = p.forum_id AND ' at line 3
can anyone outthere help us
Thank u
aaaa
|