Select DATUM felt

Jag ha en annons tabel som jag skall gora en statistik skript for.

En falt ar start_date (Typ = date, Standard = 0000-00-00).

Det jag behover att fa ut är statistik på hur mycket annonser var publicerade per år och manad.

Ar det nan som har nat tips?

Per månad:

SELECT COUNT(id) as antal, DATE_FORMAT(start_date, '%M %Y') as manad FROM dinTabell GROUP BY manad;

Per år:

SELECT COUNT(id) as antal, DATE_FORMAT(start_date, '%Y') as year FROM dinTabell GROUP BY year;

Per vecka:

SELECT COUNT(id) as antal, DATE_FORMAT(start_date, '%u %Y') as vecka FROM dinTabell GROUP BY vecka;

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

TAck sl0K. MEn hur far jag ut det data?

Har du tips?

$sql = "SELECT COUNT(id) as antal, DATE_FORMAT(start_date, '%M %Y') as manad FROM dinTabell GROUP BY manad";
$res = mysql_query($sql);
while ($svar = mysql_fetch_assoc($res)) {
    echo "Månad: {$svar['manad']}  {$svar['antal']} st. <br />\n";
}

Helt uderbart!

Komm pa en fraga till.

Jag skulle behova ordna dem sa att de skrivs ut i foljande orning:

Year 2003
Jan
Feb
March
...

Year 2004
Jan
Feb
March
...

Year 2005
Jan
Feb
March
...

???????

otestat .. men borde fungera

 $sql = "SELECT COUNT(id) as antal, DATE_FORMAT(start_date, '%M %Y') as manad FROM dinTabell GROUP BY manad ORDER BY manad DESC";
$res = mysql_query($sql);
while ($svar = mysql_fetch_assoc($res)) {
    list ($year, $month) = explode(' ', $svar['manad']);
    if (isset($akt_year) && $year == $akt_year) 
        $add_year = "";
    else {
        $akt_year = $year;
        $add_year = "Year $year<br />\n";
    }
    echo "$add_year $month  {$svar['antal']} <br />\n";
}

/red. typo.. hade använt $manad istället för $month på sista raden..

TACK!