![]() |
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:
Code:
$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads"; Code:
$query = "SELECT * FROM thread where forumid='1' or forumid='2' or forumid='3' ORDER BY lastpost DESC LIMIT $maxthreads"; |
Change as in bold below:
Code:
$query = "SELECT * FROM thread WHERE forumid != 'x' ORDER BY lastpost DESC LIMIT $maxthreads"; |
yup, thanks all, cheers!
|
All times are GMT. The time now is 08:49 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|