-2
I am trying to make a list of users who have logged in and at the same time a count of how many times each user has logged in, from log logins in a table, I can not explain very well, so will an example:
Mysql table (log logins):
Nome | Hora_de_Login
----------------------
Joao | 1519935575
Joao | 1519935475
Joao | 1519935275
Pedro| 1519935775
Pedro| 1519932575
And I would like PHP to print like this:
Nome | Numero_de_Logins
----------------------
Joao | logou 3 vezes
Pedro| logou 2 vezes
Gives a
count
withgroup by
in your consultation I believe you will solve.– rray