| Author |
 Topic  |
|
|
Mark17
Starting Member
4 Posts |
 Posted - 04 May 2001 : 14:05:03
|
I'm trying to do something like:
(new_member_name) is the (total_number_of_user) and newest member.
I want to put that in the main page. I have no clue how to impliment it though.
Thanks in advance if you are able help. I really appreciate it. 
|
|
|
Mark17
Starting Member
4 Posts |
Posted - 04 May 2001 : 19:11:10
|
hmmm it seems no body wants to hlep me 
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 04 May 2001 : 19:34:16
|
Did you want it down in the statistics section?
Do you plan on use nd st th rd ?
For example:
Bob is the 4th and newest member |
|
|
|
Mark17
Starting Member
4 Posts |
Posted - 04 May 2001 : 20:52:09
|
Hi Richard, thanks for your response.
Actualy I want to display that at the top of the defualt page.
By the way, I love the idea of using the (nd st th rd) format, it's really nice. I would really appreciate it if you could tell me how to do that.
Thank you so much.
|
|
|
|
Mark17
Starting Member
4 Posts |
Posted - 10 May 2001 : 10:16:06
|
Hi all,
Anybody can help?
Thanks
|
|
|
|
MorningZ
Junior Member
USA
169 Posts |
Posted - 10 May 2001 : 10:51:01
|
'Get Newest MemberID and Count the total
strSQL = "SELECT Max(Member_ID) AS Member_ID, Count(*) AS MemberCount FROM FORUM_MEMBERS"
Set rst = Server.CreateObject("ADODB.RecordSet")
rst.Open strSQL, my_Conn ( <<== or whatever connection obj Snitz uses )
intCount = rst("MemberCount")
intHighestID = rst("Member_ID")
rst.Close
Set rst = Nothing
'Get Name of Hightest Member
strSQL = "SELECT M_NAME FROM FORUM_MEMBERS WHERE Member_ID = " & intHighestID
set rst = Server.CreateObject("ADODB.RecordSet")
rst.Open strSQL, my_Conn
strNewestName = rst("M_NAME")
rst.Close
Set rst = Nothing
Response.Write strNewestName & " is the " & intCount
Select Case Right(intCount,1)
Case 1
Response.Write "st"
Case 2
Response.Write "nd"
Case 3
Response.Write "rd"
Case Else
Response.Write "th"
End Select
Response.Write " and newest member"
-Steve
and for the record ( and I in no way am trying to be harsh, just trying to pass some advice ), "hmmm it seems no body wants to hlep me " and "Anybody can help?" is annoying and is bad message board etiquette
if someone reads your post and chooses to help, then they will.....
Edited by - MorningZ on 10 May 2001 13:33:34 |
|
|
| |
Topic |
|
Topic Locked
