Click to See Complete Forum and Search --> : displaying by ranking


PeOfEo
02-16-2003, 04:37 PM
I want to have a page where users can update their stats but the page that all the stats will be on will need to display the users in order of rank. For example if they are ranked good I want them at the top. If they are ranked bad I want them at the bottum. The rank will be next to their name. What should I do? Should I make the ranks a variable like good=3 ok=2 bad=1 and display it by number? If so how whould I go about doing that? Oh yea I finished the message board I was working on earlyer! http://www12.brinkster.com/knightsempire/db/index.aspx Its pretty cool... well to me it is! I learned a whole lot while making this thing.

PeOfEo
02-16-2003, 05:29 PM
note* I am using asp.net also I believe my code is going to end up looking something like
DBcommand=new oledbdataadapter _
("Select MemberID, Loads, " _
& "Order by Rank Desc" _
, DBConn)

I know that is way off but memberId loads and rank are all catagories in my data base. I am using access not sql server.