Can anyone tell me...

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

Here is a start. I have no idea how to do the query. Can anyone help??

<?php

// Set this to the Forum ID to display
$forum = 20;
require("forum/admin/config.php3");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);

$forumtitle=htmlspecialchars($forum[title]);
$numberthreads=$forum[threadcount];
<A HREF="forumdisplay.php3?forumid=$forum">$forumtitl e</A> has $numberthreads Threads.

?>

90 Views and no one wants to help...

It's not that we don't WANT to help, many of us don't know HOW to help.

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

read further down in this thread for the answer
http://www.vbulletin.com/forum/showt...?threadid=2658

here's what the thread had further down

<?php
require("/full/path/to/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "select * from thread";
$resultlatest = mysql_query($query,$db);
$num = mysql_num_rows($resultlatest);
echo "<FONT FACE=\"Verdana, Arial, Helvetica, sans-serif\" SIZE=\"2\">There are currently <b>$num</b> threads on the forums.</font>";
?>

sorry didn't read your question properly... but i think you could work with this code for a per forum version - i don't know php so wouldn't have a clue

$query = "select * from thread";

This must be very resource intensive though.... you are reading all of your threads simply to find out how many there are. I think you would be better off with something like this:

SELECT COUNT(*) FROM thread

HTH.

-Chris

[Edited by Chris Schreiber on 09-08-2000 at 04:58 PM]

chris i tried SELECT COUNT(*) FROM thread

and it displayed my total thread count = 1 ?

Originally posted by eva2000
and it displayed my total thread count = 1 ?

Well that sure isn't the correct count!

I can't check this now, but I will take a look at this later tonight.... this is valid SQL, I even checked here to make sure: http://www.mysql.com/documentation/m...=Counting_rows

-Chris

Is this what you want?

http://www.extremeforums.com/include..._count.inc.php

~Chris