---
title: "Select DATUM felt"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/146084-select-datum-felt"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "mall"
published: "2006-04-26T11:58:39.000Z"
updated: "2006-04-27T13:24:34.000Z"
replies: 7
views: 388
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/php/146084-select-datum-felt"
---

# Select DATUM felt

## #1 — mall, 2006-04-26T11:58Z

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?

Permalänk: https://www.webforum.nu/p/146084

## #2 — sl0k, 2006-04-26T16:34Z

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>

Permalänk: https://www.webforum.nu/p/1804109

## #3 — mall, 2006-04-27T05:22Z

TAck sl0K. MEn hur far jag ut det data?

Har du tips?

Permalänk: https://www.webforum.nu/p/1804228

## #4 — sl0k, 2006-04-27T06:37Z

```php
$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";
}
```

Permalänk: https://www.webforum.nu/p/1804241

## #5 — mall, 2006-04-27T07:19Z

Helt uderbart!

Permalänk: https://www.webforum.nu/p/1804253

## #6 — mall, 2006-04-27T07:39Z

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
...

???????

Permalänk: https://www.webforum.nu/p/1804255

## #7 — sl0k, 2006-04-27T10:15Z

otestat .. men borde fungera

```php
 $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..

Permalänk: https://www.webforum.nu/p/1804297

## #8 — mall, 2006-04-27T13:24Z

TACK!

Permalänk: https://www.webforum.nu/p/1804352

---

Tråden på webben: https://www.webforum.nu/amne/php/146084-select-datum-felt