Joined: Feb '08
Location: United Kingdom
Age: 37 (M)
Posts: 1886
So it does lol. Actually I have often wondered what the order was. At first I thought it was the order they logged in that day but I thought it was odd I was always one of the first listed. Well maybe I wasn't when I first joined but nowadays I am. Nearly three years since I joined. Wow, time really does fly.
Joined: Aug '07
Location: Malta
Age: 43 (M)
Posts: 8350
Actually it wasn't designed to list in that order, it just kinda happened I guess. But I just checked and yes, it does list users according to when they joined. I don't know if it would be more practical to list according to when they logged in last.
My hypotesis: in fact, the list is ordered by id. Is the typical result from a SQL query without ORDER clause. By default, SQL Server ( I supposed that it's the database engine used here because web is made in asp ) returns rows order by primary key (our ID). Since ids are sequential, ordered by id is the same than ordered by date of registration.
Joined: Apr '09
Location: Australia
Age: 42 (M)
Posts: 6483
The primary key presumably for us would be our username, since you're not allowed to pick one that is already in use, it is a unique field, that all other fields are dependent on.
If you ORDER By (username) it's just gonna be an alphabetical list of user names.
My guess is it's actually an un-ordered list - which would just tally from the top to bottom, with members who first joined at the top.
Joined: Aug '08
Location: Canada
Age: 60 (F)
Posts: 2558
Posted by Administrator: Actually it wasn't designed to list in that order, it just kinda happened I guess. But I just checked and yes, it does list users according to when they joined. I don't know if it would be more practical to list according to when they logged in last.
I only found it by going to every name that was logged in at the time and clicking on name . It went in that order. I just had wondered before and had time to kill
Joined: Aug '07
Location: Malta
Age: 43 (M)
Posts: 8350
Since it took someone as intelligent as dlkiv over 2 years to spot it, I think it will be a while until someone else notices it, so I'll just leave it as it is
Joined: Aug '08
Location: Canada
Age: 60 (F)
Posts: 2558
Posted by Administrator: Since it took someone as intelligent as dlkiv over 2 years to spot it, I think it will be a while until someone else notices it, so I'll just leave it as it is
lol Tony Thanks I guess i just had some time on my hands to troll
Joined: Jan '09
Location: Philippines
Age: 43 (M)
Posts: 326
Posted by dlkiv: Just discovered that if you look at where it says at bottom of forum page
forum members logged in
that I have just figured out,( maybe some knew before but not me ), that the order of the names logged in goes in the "joined date' order.
Silly little interesting thing
Thought i would share my discovery
wow dlkv sure had nothing to do with his life, heheheh just joking... but its coll you had seen that I really dont noticed that one nice one heres a thumb up for that lol
), that the order of the names logged in goes in the "joined date' order.
