counting

[jerrylouise]

well i got my fourm almost up and running but i cant work out how to work the counters

http://www.dev.cossycomforts.com/forum.php you can see layouts.

<?php
$sql = "SELECT s.`id`, s.`catagory`, c.`title`, c.`about` FROM `forum-catagory` AS `s` LEFT JOIN `forum-topics` AS `c` ON s.`id` = c.`catagory_id` ORDER BY s.`id`";
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error()); 
   print '<table width="100%" border="0" cellpadding="3" cellspacing="0" >';
?>
<tr class="purple_top"><td width="70%"><font size="+2">Welcome to the forum <?php echo $usrname ?></font></td><td width="15%"></td><td width="15%"></td></tr>
<?php
print '<tr class="purple_top"><td width="80%">Forum</td><td width="10%">Topics</td><td width="10%">Posts</td></tr>'; 
$last_cat = ''; 
$i = 0; 
$m = 0; 
WHILE($row = mysql_fetch_array($result)) { 
    if($row['catagory'] != $last_cat) { 
        $last_cat = $row['catagory']; 
        printf("<tr class=\"purple_title\"><td>%s" . "</td><td></td><td></td></tr>", $row["catagory"]); 
    } 
    if($i++ % 2) 
      { 
         print '<tr class="wight">'; 
      } 
      else 
      { 
         print '<tr class="pink">'; 
      } 
	printf("<td><a href=\"forum_topic.php?id=%s\">%s</a>" . "</td><td>" . "</td><td>1</td></tr>", $row["title"], $row["title"], $row["topiccount"]);
    if($m++ % 2) 
      { 
         print '<tr class="wight">'; 
      } 
      else 
      { 
         print '<tr class="pink">'; 
      }
	printf("<td><font size=\"-1\">%s" . "</font></td><td></td><td></td></tr>", $row["about"]); 
}
print '</table>'; 
?>

i need it to count the number of topics, and the number of posts.

need to count subject where = topic. so there it would count all the subjects of the topics where the topic is the same

and then i need to count all the posts where in the topic feild.

[firemankurt]

I think if it were me I would do something like this:

<?php
/....... Blah blah blah....

WHILE($row = mysql_fetch_array($result)) {

$forum[$row["catagory"]][] = $row;

// Create a count for this category
$forum[$row["catagory"]] ['count'] = $forum[$row["catagory"]] ['count'] + 1;
$Total++;
}

// Then walk through the  $forum array to build your tables
// Each category will have its own count found in $forum[$row["catagory"]] ['count'];
// And total will be in $Total

[jerrylouise]

thanks i'll give this a good go. As long as it works i dont care how it works lol

[jerrylouise]

ok i tryed it out but got lost, sorry im still not very good with this. dose it not have to call the other tables in order to count them too?

[jerrylouise]

totally lost on this one >_<

[scoppc]

normally the counting doesnt occur dat way.
U will increment the number of topics and posts at the time of "add topic" and "post reply" processes. That means, u need to have two fields in "category" table, one is to keep the latest topic count and another one for post count.

To display the number of topics and posts, just do a simple query. 🙂

[jerrylouise]

ah but i went the difficult rougt and now have to work out how to call 4 tables at the same time >_<