MySql Query Display!

[[email protected]]

ok. i have a database with alot of users and usernames because every time they go to this 1 page, it uploads the username info. each time.

and i want to have a page that displays all the users and how many times they have viewed this one page.

 

but here is where i am stuck:

i dont want it to be like:

- Dave

- Angela

- Bob

- Dave

 

i want it to be like:

- Dave - 3 times

- Angela - 1 time

- Bob - 12 times

 

but i dont even know where to start, can anyone help me please?

 

 

 

[suzzane2020]

For the login process you mite be using sessions for the users...with a id or the username as the session value....so on the page u want the data for,

check if the session is set and if it is update the database ,set filed =+1 where username or id=session value.

 

I hope u gt it

[[email protected]]

oh i see, that would be a different way to do it.

ok thanks.