This is simply frustrating me now thank you to all that have helped
i can get the template to show now but no results from either forum ??
Any help or guidelines would be great thanks
PHP Code:
<?php
include("./global.php");
/////////////// CONFIG ///////////////
//
$maxposters = "10"; // change this to the number of posters you want to show.
$bc1 = "#777777"; // change to first alternating color.
$bc2 = "#555555"; // change to second alternating color.
///////////// END CONFIG /////////////
require("admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Unable to connect to database");
mysql_select_db($dbname) or die("Unable to select database $dbname");
$postsresult = mysql_query("SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE forumid IN (10,11) GROUP BY postuserid ORDER BY count DESC LIMIT $maxposters;") or die("Unable to complete query");
while ($topposters = mysql_fetch_array($postsresult))
{
if (($counter++ % 2) != 0)
{
$bc=$bc1;
}
else
{
$bc=$bc2;
}
}
eval("dooutput(\"".gettemplate("topp")."\");");
?>
09-18-2003, 06:43 PM
Threaded Mode