kickassamd Posted December 15, 2006 Share Posted December 15, 2006 [quote]SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc, c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid FROM xoops_ipb_forums f, xoops_ipb_categories c LEFT JOIN xoops_ipb_moderators m ON (f.id=m.forum_id) WHERE c.id=f.category ORDER BY c.position, f.position;[/quote]And this is the error im getting....Unknown column 'f.id' in 'on clause'What is wrong here? Quote Link to comment https://forums.phpfreaks.com/topic/30803-mysql-error/ Share on other sites More sharing options...
Barand Posted December 15, 2006 Share Posted December 15, 2006 It looks as though the table "xoops_ipb_forums" does not have a column called "id" Quote Link to comment https://forums.phpfreaks.com/topic/30803-mysql-error/#findComment-142075 Share on other sites More sharing options...
kickassamd Posted December 16, 2006 Author Share Posted December 16, 2006 That is what is strange... it does ??? Quote Link to comment https://forums.phpfreaks.com/topic/30803-mysql-error/#findComment-142305 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.