Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 HOW MANY MEMBER
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

UKWEBSITE
Starting Member

28 Posts

Posted - 20 April 2001 :  05:09:06  Show Profile

I would like to output a comment on the inc_header.asp

We currently have XX amount of members.

How would it do that please.

Nam_Trung
Starting Member

22 Posts

Posted - 20 April 2001 :  05:30:12  Show Profile
Hi,

Maybe this could work.

In config.asp add a line:
<%
DIM total_member
%>
in inc_header.asp add:

<%
strSql = "SELECT " & strTablePrefix & "TOTALS.U_COUNT "
strSql = strSql & "FROM " & strTablePrefix & "TOTALS"
set rs = my_Conn.Execute (strSql)
total_member = rs("U_COUNT")
set rs = nothing
%>

Add this line where you want to have the amount displayed:

<%=total_member%>

Good luck.

Nam Trung


Go to Top of Page

UKWEBSITE
Starting Member

28 Posts

Posted - 21 April 2001 :  07:48:31  Show Profile
Works great!!!

BTW my fault the page is

inc_top.asp





Go to Top of Page

Nam_Trung
Starting Member

22 Posts

Posted - 21 April 2001 :  10:03:36  Show Profile
I'm glad it works, because I haven't test it heheheh. oh it doesn't really matter in what file you add the piece of code, as long as the code is included in the page where you want to display the amount of members.

btw, what's the url of your forums? Just wanna have a look.

Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 21 April 2001 :  12:51:35  Show Profile  Visit tomasalsbro's Homepage
You talk about a file called inc_header.asp. What's that file? I don't have it.
What do I do in order to implement the code?
Cheers / Tomas

!-Keep distance in trafik-!
www.whiplash.pp.se
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts

Posted - 07 May 2001 :  00:15:38  Show Profile  Visit dayve's Homepage
worked for me too but I did not need this line:

<%
DIM total_member
%>

dayve
http://www.burningsouls.com/forum

Dayve
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.43 seconds. Powered By: Snitz Forums 2000 Version 3.4.07