[php] COUNT / DISTINCT

[Matthias Dierker]

At 18:03 29.05.00 +0200, you wrote:

>  MySQL Error:    1064 (You have an error in your SQL syntax near
>                  'distinct ID ) as result from
>phpOpenCounter_accesslog'
>                  at line 1)


Laut Manual gibt es COUNT(DISCTINCT) erst ab Version 3.23.2:
D.1.3 Changes in release 3.23.2
 ...
 - COUNT(DISTINCT value,[value,...]) 


>Ich möchte an die Anzahl der Zeilen kommen, welche unterschiedliche
>Einträge im Feld ID haben.

mach doch:
 SELECT COUNT(*) FROM table GROUP BY id


Gruss
Matthias