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? 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" 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 ??? Link to comment https://forums.phpfreaks.com/topic/30803-mysql-error/#findComment-142305 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.