Post Count?

[мϊкэ]

so i have to look through my mysql db's till i find the category ids? arent they displayed when you click them? and when i do find them what would i do next?

[Owen]

Just count how many people have posted them then keep them updated to save stress cause some people might post in a certain section and it might not be a tutorial "/

[Mentor]

ok heres a simple thing that can do it

athogh ypu would need a database connection to your douems database

<?php
  //Get all the topics where there in forum with id 5
$sql = mysql_query("SELECT tid FROM ibf_topics WHERE forum_id='5'");
//count them
$result = mysql_num_rows($sql);
//output
echo $result;
?>

Now the above will output how many topics are in the forum with the id 5, chnage the 5 in the exsample for the id of the forum you want to copyu topics in

(wrote in hurry so could be errors)

[мϊкэ]

nothing at all appeared what do i need to configure from that just change forum_id to the category number?

[мϊкэ]

i always get ignored :@ *bump*

[Mentor]

no to the actal number of that forum. Also you need a db connection on the page your trying to quiry from

[мϊкэ]

so what i need to add

//MySQL Hostname
$hostname = 'localhost';

//MySQL Database Username
$sqlname = 'my username';

//MySQL Database Password
$sqlpass = 'password';

//MySQL Database Name
$mysqldb = 'db name'; 

to that code you gave me?

[Mentor]

add this above it

<?php



$dbh = mysql_connect ("localhost", " DATABASE USER ", " DATABASE NAME ") or die ('DB error due to: ' . mysql_error());

mysql_select_db (" DATABASE NAME ");

?>

[мϊкэ]

so in the end it will look like this?

<?php
$dbh = mysql_connect ("localhost", "USER_DB", "DB") or die ('DB error due to: ' . mysql_error());
mysql_select_db ("DB");
//Get all the topics where there in forum with id 5
$sql = mysql_query("SELECT tid FROM ibf_categories WHERE id='3'");
//count them
$result = mysql_num_rows($sql);
//output
echo "$result";
?>

this is what im usin now and its not workin still (i changed the DB parts though)

in phpmyadmin this is what i found in ibf_categories on the tutorial one

id position state name

3 7 1 Tutorials

[Mentor]

OK easyer way to find out the forum is go in to the form conting the tutorials, and look at the id of it at the top, from the index.php?showforum=5 athogh what ever number u get there being the correct id of ythe forum