Can anyone tell me...

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

Um...

Wouldn't you just have to get the forumid, then just do something simple like.

<?php

$query = "select forumid from thread where forumid='theforumidyouchose'";

$result = mysql_query($query);

$num_rows = mysql_num_rows($result);

print "There are $num_rows results in that forum";

?>

Keep it simple, thats the way to do it I think.

Originally posted by Chris Schreiber

$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]

Not 100% sure, but shouldt that be something more like:

$query=mysql_query("SELECT COUNT(threadid) AS totalthreads FROM thread");

Then you could just grab the total threads by doing something like:

$row=mysql_fetch_array($query);
$totalthreads = $row[totalthreads];
echo "$totalthreads total threads";

???

I didnt think of this the first time, because im not very knowledgable on server load / mysql strain.....etc... So i guess i really didnt care

~Chris

<?php

require("forum/admin/config.php3");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$query=mysql_query("SELECT COUNT(threadid) AS totalthreads FROM thread");
$row=mysql_fetch_array($query);
$totalthreads = $row[totalthreads];
echo "$totalthreads total threads";

?>

That code shows the total number of posts on the board, not in a specific forum.

FORUM LIST W/ TOTAL THREADS ON NON VB PAGE

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

Usage:

include("/full/path/to/forumlist_with_count.inc.php");

forumlist_with_count.inc.php

<?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 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> Currently <b>$latest_array[threadcount]</b> threads</FONT><BR>";
}
?>

HTH

~Chris

Oh yeah,

In my one I left out the MySQL connect code. You'll have to connect to the MySQL and choose the database that vBulletin is in.

Its killing me how a person can ask a question and people can take is so far off topic, and get so turned around

Originally posted by Zothip
<?php

require("forum/admin/config.php3");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$query=mysql_query("SELECT COUNT(threadid) AS totalthreads FROM thread");
$row=mysql_fetch_array($query);
$totalthreads = $row[totalthreads];
echo "$totalthreads total threads";

?>

That code shows the total number of posts on the board, not in a specific forum.

Read this thread a little closer, im not even the one who posted that code

Roger, I stand corrected. You were correcting someone elses code that had nothing to do with what i asked about in the first place

Originally posted by Zothip
Roger, I stand corrected. You were correcting someone elses code that had nothing to do with what i asked about in the first place

No problem.....so is the code I gave on the last page what you wanted?

~Chris

Originally posted by TechTalk

No problem.....so is the code I gave on the last page what you wanted?

~Chris [/B]

No, it isnt. I am looking to display the total threads in one forum only. (ie. <A HREF="forumdisplay.php3?forumid=$forum">$forumtitl e</A> has $numberthreads Threads.)

-Thomas