Hi, i am currently writing a php script that use's mysql, i'll cut straight to the point - heres the sql code:
Code:
SELECT f.id as id, f.forum_name as forum,
f.forum_desc as description,
count(forum_id) as threads, u.name as mod
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
And when it try to load the page that its on, i get 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 ' at line 3
If anyone can spot any errors in the code / or correct it, it will be greatly appreciated.
Bookmarks