Snitz Forums 2000 - Pulling Database Info

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Current Version (Old)

Pulling Database Info

New Topic

Topic Locked

Printer Friendly

Author

Topic

DarlingBri
Junior Member

United Kingdom
378 Posts

Posted - 11 March 2001 : 09:47:47

If I know the category number and the Forum number, is it possible to pull the total number of Posts for a *particular* topic?

Like, "There are X posts in our very poupular Databases Forum."

I want to use this on default.asp but outside the main category table.

Also, I want to pull the total number of posts and put them at the top of my page. I tried this with <font face="<% =strDefaultFontFace %>" size="1">RESOURCES TODAY: <% =Posts %> </font>

and it doesn't work.... :(

--Bri

"Bother," said Pooh, as Piglet was assimilated by the Borg.

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 11 March 2001 : 17:12:30

it is much simpler than that, there is a field in TOPICS called T_REPLIES, this is what you require.

DarlingBri
Junior Member

United Kingdom
378 Posts

Posted - 11 March 2001 : 17:45:48

quote:

it is much simpler than that, there is a field in TOPICS called T_REPLIES, this is what you require.

That's great! I'm not sure of how to use it, though--can you help at all?

--Bri

"Bother," said Pooh, as Piglet was assimilated by the Borg.

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 11 March 2001 : 18:18:12

ok.


<%
strSQL = "SELECT T_REPLIES FROM " & strTablePrefix & "TOPICS " &_
         "WHERE TOPIC_ID = " & YOURTOPICID
set rs = my_conn.excute (strSQL)
if not rs.eof then
      response.write "<font face=""" & strDefaultFontFace & """ size=""1"">" &_
                     "RESOURCES TODAY: " & rs("T_REPLIES") & "</font>"
end if
rs.close
%>

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.37 seconds.