[dbs] Einträge nach Monaten gruppieren und ausgeben

[Sven Eicher]

Hallo

> SELECT COUNT(*) as count,YEAR(ip_date) as year, MONTH(ip_date) as month,
> DAY(ip_date) as day FROM zitat_stats WHERE YEAR(ip_date)= '2004' AND
> MONTH(ip_date)= '1 ' GROUP BY DAY(ip_date)

Versuchs mal damit. Aber Achtung, völlig ungeprüft!

SELECT COUNT(*) AS count, ip_date AS jahr, ip_date AS monat, ip_date AS tag
FROM zitat_stats 
WHERE YEAR(jahr) = '2004' AND MONTH(monat) = '1' 
GROUP BY DAY(tag)

-- 
Koala