PDA

View Full Version : Help with some code


Sarge
04-03-2001, 07:23 PM
This is the latest threads on the front of the page hack

How would I excluse forum 9 from being shown?
I know this has been discussed here but the other code does not match mine..
Thanks in advance

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

require("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 "<img src=\"/forums/images/smalldoc.gif\" width=\"4\" height=\"4\" alt=\">\" border=\"0\" align=\"absmiddle\"><FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\"> <a href=\"/forums/showthread.php?threadid=$latest_array[threadid]\">$latest_array[title]</a></FONT><BR>";
}

?>

tubedogg
04-04-2001, 01:40 AM
Originally posted by Sarge
$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads";

Change that to
$query = "SELECT * FROM thread WHERE forumid<>'9' ORDER BY lastpost DESC LIMIT $maxthreads";

;)

Sarge
04-04-2001, 01:53 AM
Thanks Man
Chris