View Full Version : Sorting Members By Most Active

03-01-2007, 01:15 PM
Hi all,
Am a complete newbie at ASP, I currently have a site which has a MySQL backend database, users can apply to join and then once joined they can edit there information. I can login using a username/password senario. From there I can see all users currently active, and whom I am waiting to join... I can also search the users Birthdays that are coming up and delete users... Pretty straight forward. I want to be able to see the last 5 users who logged on? Anyone know how to do this or if it's fairly complicated?

03-02-2007, 07:00 AM
This is very very very easy.
First create your database structure then start coding...


03-02-2007, 07:10 AM
Have you any plan on your mind how will you do this?

03-02-2007, 07:14 AM
How many things are ready with you?


03-02-2007, 10:47 AM
Well everything on the backend is done, database... But I don't know what the next step is...

03-02-2007, 10:52 AM
It depends, if there is a column in the database indicating the last login time stamp, it is fairly easy. Select the TOP 5 records from the table with a descending sort on the last login field. These records can then be displayed in an asp page. If this column is not present, then you have to alter the table to add the column, change the login page to update the last login column on successful login. Then you can do the same as before mentioned.

03-02-2007, 11:00 AM
I'v added the column in the database and it all works, but not sure how to impliment it into the ASP.NET page... I will post the page a little later