Sure thing Bob.
This is what I did.
I created fields in the members table called winSTR loseSTR winSTRbest
loseSTRbest
The winSTR is the current streak, loseSTR is the current losing streak,
winSTRbest is the best winning streak the player has had, and loseSTRbest is
the worse losing streak the player has had.
Now on the reportasp.asp page, since only the loser reports, I put in a few
sql statements.
The first thing it did was set the reporting person's currnet win streak to
0, since he just lost and that is why he is reporting.
Then the next statement added a win the the person who won's current win
streak field.
Then I had it do a check, to see if the current win streak, was better than
the best win streak, if so replace it, if not, continue on.
Then it added one to the losers current losing streak, and checked to see if
that was higher than the worst losing streak, if so, replace it, if not,
continue on, which is closing the connection, and a response.redirect
Not sure if this was the most efficient way of doing it, but it would seem
it would be faster than going through the table of matches (which is about
8000 records). It takes less than a second to process this, so it works fine
for me.
Hope this will help someone
Bam
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:OW**************@tk2msftngp13.phx.gbl...
Jeff wrote: Nevermind all. I figured out an easy way to do it.
Is there a way to delete an initial post from the NG, like in this
case, where help is no longer needed for this topic??
No, but you can help out other users who are googling for help with their
own problems by posting your solution. :-)
Part of the value of using newsgroups, at least in my experience, is the
opportunity to help others as you receive help.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"