Chapter 16 problem
When I try to view a certain post from the forum I get this errormessage:
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, p.update_id, u2.name as updated_by FROM forum_forum f JOIN forum_posts p ON' at line 1
SELECT SQL_CALC_FOUND_ROWS p.id, p.subject, p.body, p.date_posted, p.date_updated, u.name as author, u.id as author_id, u.signature as sig, c.count as postcount, p.forum_id as forum_id, f.forum_moderator as mod, p.update_id, u2.name as updated_by FROM forum_forum f JOIN forum_posts p ON f.id = p.forum_id JOIN forum_users u ON u.id = p.author_id LEFT JOIN forum_users u2 ON u2.id = p.update_id LEFT JOIN forum_postcount c ON u.id = c.user_id WHERE (p.topic_id = 4 OR p.id = 4) ORDER BY p.topic_id, p.date_posted LIMIT 0,10
edit: problem is solved
Last edited by drak3n; March 9th, 2011 at 06:59 AM.