Im getting an error message now though!
mySQL query error: SELECT t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size,
m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml
FROM ontheground_topics t
LEFT JOIN ontheground_members m ON (t.starter_id=m.id)
LEFT JOIN ontheground_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ontheground_posts p ON (p.topic_id=t.tid AND p.new_topic=1)
LEFT JOIN ontheground_forums f on (f.id=p.forum_id)
WHERE t.forum_id IN (-1,78,) AND p.forum_id NOT IN(2)
AND t.approved=1 AND (t.moved_to IS NULL or t.moved_to='')
ORDER BY t.pinned DESC, t.start_date DESC
LIMIT 0,9
mySQL error: 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 ') AND p.forum_id NOT IN(2)
AND t.approved=1 AND (t.move
mySQL error code:
Date: Friday 11th of June 2004 03:52:51 PM |