Can anyone tell me...

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

Originally posted by Michael
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.

Indeed, I'm not quite sure why no one is using this:

<?php 
require( "forum/admin/config.php3" ); 
$db = mysql_connect( $servername, $dbusername, $dbpassword ); 
mysql_select_db( $dbname ); 
$query=mysql_query( "SELECT COUNT( * ) AS totalthreads FROM thread WHERE forumid = $forumid" ); 
$row = mysql_fetch_array( $query ); 
$totalthreads = $row[ totalthreads ]; 
echo "$totalthreads total threads"; 

?>

It's simple.

Easy.

And works.

[Edited by mrogish on 09-11-2000 at 01:22 AM]

That way works as well - one of the books I have says that mysql_num_rows function isa better way, but what you have is better then using the threadcount field.

lol!

?

Originally posted by Michael
That way works as well - one of the books I have says that mysql_num_rows function isa better way, but what you have is better then using the threadcount field.

The only reason why I would use count( ) is that:

1. count is a built in SQL function -- so it's far more efficent than selecting everything in the table.
2. Once you get a result you directly access the array $result[ somevar ]; rather than executing another function (mysql_num_rows( )) -- this would shave off some overhead on PHP's account I would believe.
3. That's what the count( ) function is supposed to do!
4. There is no number 4!

But, all of the methods work, it's up to whomever wanted it in the first place to decide!

Thanks guys...

I guess your right, cause SQL functions are faster then PHP functions.