#1064 Syntaxfehler geschachtelte Anfrage

[ChrisB]

Hi,

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5

Eingabe:

SELECT SUM(visitor_count_per_day) AS visitorCount
FROM
(SELECT date, COUNT(client_ip) AS visitor_count_per_day
FROM counter
GROUP BY date;)

  
Na erst mal gehört der Smilie am Ende da nicht rein, und dann willst du Spaltennamen, die Schlüsselwörter sind, natürlich entsprechend quoten (bzw. von vornherein vermeiden).  
  
MfG ChrisB  
  

-- 
RGB is totally confusing - I mean, at least #C0FFEE should be brown, right?