I've created a password protected Music Database. What I now need is, whenever a member logs in, the time and date of his login should be noted. I only need to record the last time he was logged in. Something like "You last logged in on 21st July, 2005 at 03:30." How do I go about it?
Also, I would like a counter to keep track of how many times in all the user has logged in. I'm guessing that this can be done by adding an Update query which will increment a counter field each time the user logs on. Is this the best way, or am I missing something here?