Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    Regular Coder
    Join Date
    Mar 2006
    Posts
    459
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Sorting Members By Most Active

    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?

  • #2
    SSJ
    SSJ is offline
    Regular Coder
    Join Date
    Mar 2007
    Posts
    230
    Thanks
    0
    Thanked 4 Times in 4 Posts
    This is very very very easy.
    First create your database structure then start coding...

    -SSJ

  • #3
    SSJ
    SSJ is offline
    Regular Coder
    Join Date
    Mar 2007
    Posts
    230
    Thanks
    0
    Thanked 4 Times in 4 Posts
    Have you any plan on your mind how will you do this?

  • #4
    SSJ
    SSJ is offline
    Regular Coder
    Join Date
    Mar 2007
    Posts
    230
    Thanks
    0
    Thanked 4 Times in 4 Posts
    How many things are ready with you?

    -SSJ

  • #5
    Regular Coder
    Join Date
    Mar 2006
    Posts
    459
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Well everything on the backend is done, database... But I don't know what the next step is...

  • #6
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    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.
    I am the luckiest man in the world

  • #7
    Regular Coder
    Join Date
    Mar 2006
    Posts
    459
    Thanks
    3
    Thanked 0 Times in 0 Posts
    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


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •