Count Row From Two Tables...

[Unholy Prayer]

Ok, I'm making a forum software for my website and I want to put the number of replies for the listed forum. How would I count the number of rows of the replies table that are in the certain forum?

[boo_lolly]

that depends on how your database is setup, but something like this may do the trick:

<?php
        $sql = "SELECT * FROM your_table WHERE forum = '". $forumName ."'";
        $query = mysql_query($sql);
        $numRows = mysql_num_rows($query);

        echo "Number of Replies: ". $numRows ."<br />\n";
?>

[Unholy Prayer]

That would only work for my count threads code which I already have working.  This is my table structure:

Forums Table:

 

Threads Table(fid= forum the thread is in)

 

Replies Table(tid=thread the reply is in)

[boo_lolly]

so what exactly are you trying to do?

[Unholy Prayer]

I am trying to count the number of replies that are in the forum being listed.

[Snooble]

create a while loop of the sql db. add all the users' posts together and store.

 

Or (from scratch) every time a post is stored ++ a variable/tablecell

 

Snooble