[upnorth]

Originally Posted by WetWired

You'll need to add

AND(post.visible==1)

to the query, or something similar. It's hard to say without the query.

I think the query part of the code is as follows

$NewestNews = $db->query("
   select t.*,p.pagetext, f.title as ft
   from ".TABLE_PREFIX."thread t
   left join ".TABLE_PREFIX."post p on(p.postid=t.firstpostid)
   join ".TABLE_PREFIX."forum f on(f.forumid=t.forumid)
   where f.forumid != 48 AND f.forumid != 42 
   order by dateline desc
   limit 0,$Amount");

I tried both

$NewestNews = $db->query("
   select t.*,p.pagetext, f.title as ft
   from ".TABLE_PREFIX."thread t
   left join ".TABLE_PREFIX."post p on(p.postid=t.firstpostid)
   join ".TABLE_PREFIX."forum f on(f.forumid=t.forumid)
   where f.forumid != 48 AND f.forumid != 42 AND p.visible==1
   order by dateline desc
   limit 0,$Amount");

and

$NewestNews = $db->query("
   select t.*,p.pagetext, f.title as ft
   from ".TABLE_PREFIX."thread t
   left join ".TABLE_PREFIX."post p on(p.postid=t.firstpostid)
   join ".TABLE_PREFIX."forum f on(f.forumid=t.forumid)
   where f.forumid != 48 AND f.forumid != 42 AND post.visible==1
   order by dateline desc
   limit 0,$Amount");

and neither worked? Have I provided enough of the code?