Count og GROUP BY

SELECT COUNT(browser) AS antal, browser FROM stats GROUP BY browser

select browser, count(*) from stats group by browser;

samme fejl på begge!!!
Record set empty!!

??!?

Har du overhovedet data i din tabel?

Må vi lige se din tabelstruktur og nogle af de data, der ligger i den?

SQL: select * from stats;

Data:
StatID UserID SessionID Date IP script_name Href Post Application Browser Domain Method URL
1 0 779022556 07-01-2002 20:30:52 62.79.37.20 /galleri/admin_stats_SQL.asp - - Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) www.nanosoft.dk GET /galleri/admin_stats_SQL.asp
2 0 779022556 07-01-2002 20:31:14 62.79.37.20 /galleri/admin_stats_SQL.asp - - Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) www.nanosoft.dk GET /galleri/admin_stats_SQL.asp
3 0 779022556 07-01-2002 20:31:15 62.79.37.20 /galleri/admin_stats_SQL.asp - - Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) www.nanosoft.dk GET /galleri/admin_stats_SQL.asp
4 0 779022556 07-01-2002 20:31:16 62.79.37.20 /galleri/admin_stats_SQL.asp - - Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) www.nanosoft.dk GET /galleri/admin_stats_SQL.asp
5 0 779022556 07-01-2002 20:31:17 62.79.37.20 /galleri/admin_stats_SQL.asp - - Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) www.nanosoft.dk GET /galleri/admin_stats_SQL.asp
6 0 779022556 07-01-2002 20:31:38 62.79.37.20 /galleri/billed_index.asp http://www.nanosoft.dk/galleri/billed_index.asp page=2 Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) www.nanosoft.dk GET /galleri/billed_index.asp
7 0 779022556 07-01-2002 20:31:39 62.79.37.20 /galleri/getpic.asp http://www.nanosoft.dk/galleri/billed_index.asp?pa mode=negl&ID=322 Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) www.nanosoft.dk GET /galleri/getpic.asp
8 0 779022556 07-01-2002 20:31:39 62.79.37.20 /galleri/getpic.asp http://www.nanosoft.dk/galleri/billed_index.asp?pa mode=negl&ID=323 Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) www.nanosoft.dk GET /galleri/getpic.asp
9 0 779022556 07-01-2002 20:31:41 62.79.37.20 /galleri/getpic.asp http://www.nanosoft.dk/galleri/billed_index.asp?pa mode=negl&ID=324 Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) www.nanosoft.dk GET /galleri/getpic.asp
10 0 779022556 07-01-2002 20:31:41 62.79.37.20 /galleri/getpic.asp http://www.nanosoft.dk/galleri/billed_index.asp?pa mode=negl&ID=325 Galleri Mozilla/4.0 (compatible; MSIE 6.0; Windows