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?just a simple query?
Select name from tblusers order by lastlogin desc limit 0,5
Something like this?
You have to log each time a member logs in
or in the datatable you can sort it....
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?just a simple query?
Select name from tblusers order by lastlogin desc limit 0,5
Something like this?
You have to log each time a member logs in
or in the datatable you can sort it....