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,$dbpassw ord);
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:

$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads";

To something like this:

$query = "SELECT * FROM thread where forumid='1' or forumid='2' or forumid='3' ORDER BY lastpost DESC LIMIT $maxthreads";

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:

$query = "SELECT * FROM thread WHERE forumid != 'x' ORDER BY lastpost DESC LIMIT $maxthreads";

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

yup, thanks all, cheers!