How to display the number of posts on a thread to your homepage

[The slime]

Is this possible ? Example a thread named "A" has 6 posts . Can I have 6 display on my home page ? Any help is much appreciated.

[Lynne]

Is your homepage some custom coded page? Do you have a link to show us this on someone else's site or else an image to explain what you want?

[The slime]

No however I have seen it . Mostly for positive and negative comments of a company . So in the forum it would have a "positive thread " and a "negative" thread . So let's say 5 people posted under the positive thread and 2 people posted on the negative thread .
On the home page it would show positive (5) negative (2) for the company .

[Lynne]

You can just do a query on the thread table to get the number of posts in that thread - thread.replycount.

[Simon Lloyd]

No however I have seen it . Mostly for positive and negative comments of a company . So in the forum it would have a "positive thread " and a "negative" thread . So let's say 5 people posted under the positive thread and 2 people posted on the negative thread .
On the home page it would show positive (5) negative (2) for the company .What do you mean "Home page"? forumhome or forumdisplay?

[The slime]

A non forum php page .

[Lynne]

Then yes, you may just query the vbulletin database to get the number of replies and then put that information on your page.

[The slime]

Thanks Lynne for your time . I usterstand how to query the database . I just dont know what php code to put at my homepage to get fetch this info .

[Lynne]

Well, I don't know how you have written your queries in the home page, so I really can't help you with the exact code. All I can tell you is that you want to get thread.replycount WHERE thread.threadid = the id of the thread you want.

[The slime]

this is the php in mysql
$sql = "SELECT replycount FROM thread WHERE threadid = 84\n"
. " LIMIT 0, 30 ";

I just want it the reply # to populate on my blank .php test page .

here is my query
SELECT replycount FROM thread WHERE threadid = 84

[Lynne]

The query looks just fine (except why do you use LIMIT - you should only be getting one row). After you do the select, you need to do a mysql_fetch_array to get the actual data.

[The slime]

Thanks Lynn for your help I did get it working . I was getting a error and it was driving me nuts . I was using ' instead of ` in parts of the code. So that lead to me thinking the problem was something else. lol

[Lynne]

Glad you got it working.