I want to see how many time does the user logged onto the system.
Could you please tell me what is the best way to put the login number of times for that specific user to the users table.
Thank you.
store each login in a separate table and do a simple COUNT() query.
or have a field number_logins and do as part of the login script a sql statement UPDATE table_name number_logins = number_logins + 1 WHERE username ='some_user'