Ima nekoliko nacina, najlaksi je (mini tutorial):
select count(*) from clickovi group by id
a posto tebi treba i username moras da joinujes tu tabelu
select count(*) as cnt, users.username from clickovi left join users on clickovi.id = users.id group by clickovi.id
i dobijes onda records:
cnt username
--------
2 pera
7 zika
1 laza
Napomena: ovde ce biti ignorisani svi koji nemaju ni jedan klik, za prikaz i onih koji imaju 0 - potrebna je druga tehnika.
__________________
Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman
I don't always know what I'm talking about but I know I'm right!
|