Sortering af SQL - Group?

Ser lidt uoverskueligt ud i EXP
kig her.
http://get2hits.danielbahl.info/exp.txt

Det kan man da:
SELECT refere FROM tabel GROUP BY refere ORDER BY refere

HITS:
$sql = "SELECT refere, count(*) as hits FROM tabel where 1 group by refere order by hits";
$result = mysql_query($result);
while($row = mysql_fetch_array($result))
{
    echo $row['refere']." ".$row['hits']."<br>";
}
Browsere:
$sql = "SELECT count(*) FROM tabel where 1";
$result = mysql_query($sql);
$hits = mysql_result($result,0);
$sql = "SELECT browser, count(*) as hits FROM tabel where 1 group by browser order by hits";
$result = mysql_query($result);
while($row = mysql_fetch_array($result))
{
    echo $row['browser']." ".(($row['hits']/$hits)*100)."%<br>";
}

er browser-tallene opdelt i særskilt tabel med tal, eller ligger det i hver brugerrække med indhold fra $_SERVER['HTTP_USER_AGENT'] ?

Såvidt jeg kan se er "WHERE 1" bare en tidsrøver...

$sql = 'SELECT referer, COUNT(*) AS hits FROM tabel GROUP BY referer ORDER BY hits ASC';

du mener vel,
$sql = 'SELECT refere, COUNT(*) AS hits FROM tabel GROUP BY refere ORDER BY hits DESC';

? :)

andy: Har bare for vane at rette stavefejl...

Regin, Jeg mangler stadig at teste Browserne, jeg vender tilbage!