SQL Question

[NZ_Kiwis]

This only displays one results.... why does it not list ever results???

$result = mysql_query ("SELECT * FROM COUNTER GROUP BY FROM_UNIXTIME(VisitTime, '%Y-%m-%d')") or die("INSERT error: ".mysql_error());
WHILE ($row = mysql_fetch_array($result)){
$time = $row['VisitTime'];
$time2 = strftime("%A %d/%m/%y", $time);
echo $time2;
echo "<br>$time";
echo "<br>";
}

[Weedpacket]

First thing I see is that all the columns returned have to either be used only in aggregate functions (so that all the values in the same group get bundled into one row of the result set), or be the columns named in the GROUP BY clause. What happens if there are columns that are not in either category is an error (or at least, it should be - knowing MySQL it would probably make something up at random).