[FIXED] how do i count the amount of rows under a username?

Issue

I am making a forum for my school project and on my home page I want to make some kind of a leaderboard where you can see the top 10 posters + how much they have postet. Ill add a picture of my data base so if you maybe know how it would work please let me know. Database

Solution

I don't know what you mean, but if you mean the database query, it can be something like this:

SELECT username, 
       COUNT(*) AS total_post 
FROM your_table 
GROUP BY username 
ORDER BY COUNT(*) DESC 
LIMIT 10

Answered By - Toto Prasetyo

Answer Checked By - David Marino (PHPFixing Volunteer)