ainoy31 Posted October 13, 2007 Share Posted October 13, 2007 Hello- I can not figure out why this code is not working. SELECT f.id as id, f.forum_name as forum, f.forum_desc as description, count(p.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 I get the message that the 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 I have looked ove this many times and need a second eye. Much appreciation. Quote Link to comment https://forums.phpfreaks.com/topic/73058-solved-query-issue/ Share on other sites More sharing options...
Barand Posted October 14, 2007 Share Posted October 14, 2007 MOD is a MySQL reserved word Quote Link to comment https://forums.phpfreaks.com/topic/73058-solved-query-issue/#findComment-368907 Share on other sites More sharing options...
ainoy31 Posted October 16, 2007 Author Share Posted October 16, 2007 changed mod to something else like modder worked. much appreciation. Quote Link to comment https://forums.phpfreaks.com/topic/73058-solved-query-issue/#findComment-370916 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.