...

View Full Version : Sorting Members By Most Active



tomyknoker
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?

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

-SSJ

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

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

-SSJ

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

Roelf
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.

tomyknoker
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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum