Help - Ekk... bad bad :)

[etones]

Hi all, i use asimply script that grabs the 10 latest posts and puts them on the main page.

However i've just setup a moderator forum and dont want posts from here being displayed. What do I do/change?

The script im using at the moment is this:

<?php
// Set this to the max number of threads to display
$maxthreads = 10;

require("/home/etones/public_html/forums/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<tr><td width=25 align=right height=15><img border=0 src=\"http://www.e-tones.co.uk/images/main/bullet.gif\" width=17 height=9></td><td width=237 height=15><font color=#000080 size=1>
<A HREF=\"http://www.e-tones.co.uk/forums/showthread.php?threadid=$latest_array[threadid]\" target=_blanc>$latest_array[title]</A></font></td></tr>";
}

?>

Thanks everyone!!

Change this line:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



To something like this:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Add all the forumid's of those forums that you would like to be INcluded in the query. Don't add id's of private forums and such. With nearly 70 forums myself that line can become quite long ;)

Change as in bold below:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


and set X to the forum number that you don't want included.

yup, thanks all, cheers!