Quote:
Originally Posted by Almax1
No joy filburt1 
inserted this code
PHP Code:
<?php
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")."\");");
?>
result= Unable to complete query
could this be the template ??
|
Don't include a semicolon in the query; only do that in the mysql command-line client.