Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Hello everyone ... I have the following concern if they help me ...
#1
I have a table called users, this has the fields: id, user, pass ...

I was thinking of showing on the web the last access of a user and for this I think adding a field that is called ultimo_acceso and creating the sentence: UPDATE users SET ultimo_acceso = getdate () Where user = user could work ....

My big concern is that every time the user enters the date it will be updated but not the previous one will be saved and my idea is to have a history of the accesses of all the users ...


some idea ??, will be that I will have to create some other table and try to redirect the data with an insert ??

I thank you very much from now ..

Ahhh had another doubt also if they take advantage of the momentum, hehehe, it's about showing users who are online, but this is more difficult apparently ...

thanks.
 Reply
Messages In This Thread
Hello everyone ... I have the following concern if they help me ... - by o4519643 - 12-19-2018, 11:22 AM


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnol├│gicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes