npr
Code:
id: datum | live
1: 2004-11-05 | 1
2: 2004-11-05 | 1
3: 2004-11-06 | 1
4: 2004-11-06 | 1
5: 2004-11-06 | 1
6: 2004-11-06 | 1
7: 2004-11-04 | 1
8: 2004-11-04 | 1
9: 2004-11-03 | 1
10: 2004-11-03 | 1
11: 2004-11-03 | 1
id: datum | live
1: 2004-11-05 | 1
2: 2004-11-05 | 1
3: 2004-11-06 | 1
4: 2004-11-06 | 1
5: 2004-11-06 | 1
6: 2004-11-06 | 1
7: 2004-11-04 | 1
8: 2004-11-04 | 1
9: 2004-11-03 | 1
10: 2004-11-03 | 1
11: 2004-11-03 | 1
znaci poslije select-a bih trebao dobiti int 2
select count(*) as broj WHERE datum=datum AND live=1
ce vratiti 11... znaci meni samo treba koji jos uslov da dodam (probao sam nesto tipa SUM(live) > 2...) da bih izbacio 1,2,7,8 rekorde iz counta :)
znam da sam konfuzan sam sebi ali ako je neko skontao sta mi treba neka proba pomoci, ako ne onda neka se bar javi da jos pojasnim :)
"nice town, i'll take it..."