vBulletin

Thank you for visiting. This is our website archive. Please visit our main website by clicking the banner above.
vBulletin FAQ is dedicated to helping the forum owner build, manage and profit from his vBulletin Forum
vBulletin Web Hosting - Free skins and styles for your vBulletin - Search Engine Optimization




The SQL for finding number of replies

capebretoner
03-15-2006, 06:22 AM
I am wondering what is the easiest SQL line that will get the number of replies made in a specific thread?

Noppid
03-15-2006, 07:44 AM
select replycount from thread where threadid=xx limit 1

capebretoner
03-15-2006, 07:46 AM
select replycount from thread where threadid=xx limit 1
AWESOME Thanks :)

Noppid
03-15-2006, 01:33 PM
No problem. Hope it worked out.

P.S. Don't forget the table prefix stuff. ;)

capebretoner
03-15-2006, 05:46 PM
No problem. Hope it worked out.

P.S. Don't forget the table prefix stuff. ;)
Do you know what, I did forget that, so my test forum was down for about 30 secs ;)

Noppid
03-15-2006, 09:53 PM
hehe, a common oversight. Good Catch.


vBulletin

seo book

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum