Can anyone tell me...

how I can post the total number of threads in a certain forum on a non-vb page??

Which forum? whats the id??? The above code could easily be modified to only show one

Originally posted by TechTalk
Which forum? whats the id??? The above code could easily be modified to only show one

The forum ID i am trying to post the total threads for is: 20

<?php
require("/full/path/to/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "SELECT forumid,title,threadcount FROM forum WHERE forumid=20 ORDER BY title ASC";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
<A HREF=\"http://www.extremeforums.com/forums/forumdisplay.php?forumid=$latest_array[forumid]\">$latest_array[title]</A> has<b>$latest_array[threadcount]</b> threads</FONT><BR>";
}
?>

Whenever you need me to bow down and kiss your feet in public, let me know!!

Originally posted by Zothip
Whenever you need me to bow down and kiss your feet in public, let me know!!

LOL! Heres an update version for you:

<?php
require("/full/path/to/forums/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
if (isset($forumid)==0 or $forumid=="") {
$query = "SELECT forumid,title,threadcount FROM forum ORDER BY title ASC";
}else  {
$query = "SELECT forumid,title,threadcount FROM forum WHERE forumid=$forumid";
}
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
<A HREF=\"http://www.extremeforums.com/forums/forumdisplay.php?forumid=$latest_array[forumid]\">$latest_array[title]</A> Currently <b>$latest_array[threadcount]</b> threads</FONT><BR>";
}
?>

Just call it like this:
http://www.extremeforums.com/include....php?forumid=2

~Chris

What was wrong with my code? It did exactly what you needed

I think a little feet kissing is deserved

Anyway - selecting all the the forumid's and then doing a myqsl_num_rows on it is going to be more accurate then selecting the threadcoutn thing, which is the main difference between the two versions.

You are only selecting numbers as well, so even if you have alot of threads it isn't going to be server intensive.

I like to try to make everything accurate, so I would do it that way

Originally posted by Michael
I think a little feet kissing is deserved

Anyway - selecting all the the forumid's and then doing a myqsl_num_rows on it is going to be more accurate then selecting the threadcoutn thing, which is the main difference between the two versions.

You are only selecting numbers as well, so even if you have alot of threads it isn't going to be server intensive.

I like to try to make everything accurate, so I would do it that way

Hes trying to get the total number of threads in a particular forum.........so getting the value from the "threadcount" field is most accurate because it tells you exactly how many threads are in that forum

Just my $0.02

~Chris

But threadcount is incremented everytime something is posted, but if there was an error in MySQL and some information was deleted then threadcount would be inaccurate. If you wanted to delete a post through PhpMyAdmin then threadcount would be wrong.

Using a field that is incremented to keep count isn't very accurate.