Snitz Forums 2000 - Count Members

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/O Code)

Count Members

New Topic

Topic Locked

Printer Friendly

Author

Topic

Tmpj
Junior Member

Denmark
467 Posts

Posted - 08 October 2002 : 05:56:33

I need to have the total Members count, how do I do that?

laser
Advanced Member

Australia
3859 Posts

Posted - 08 October 2002 : 05:57:30

scroll down to the bottom of the forum home page.

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 08 October 2002 : 07:21:10

SELECT COUNT(*) FROM FORUM_MEMBERS

Kiwihosting.Net - The Forum Hosting Specialists

Tmpj
Junior Member

Denmark
467 Posts

Posted - 08 October 2002 : 08:32:37

Hey Gremlin, can you make me a complete conn string where ASP connects to the database and counts the number of members. And so I could use it so:

if countmember > 5 then
...

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 08 October 2002 : 08:51:01

strConnString = Use your own Snitz connection String Here

set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString

strSQL = "SELECT Count(*) AS CountMember FROM forum_Members"
set rsMember = my_Conn.Execute(strSQL)
CountMember = rsMember("CountMember")

if CountMember > 5 ....

Kiwihosting.Net - The Forum Hosting Specialists

Tmpj
Junior Member

Denmark
467 Posts

Posted - 08 October 2002 : 13:48:09

Thank You Very Much!!!

Edited by - Tmpj on 08 October 2002 13:51:00

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 08 October 2002 : 17:50:41

Kiwihosting.Net - The Forum Hosting Specialists

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 1.19 seconds.