Zapytanie zliczające ilość komentarzy w newsie Opcje

[tommy4]

[SQL] pobierz, plaintext 
SELECT n.title AS ntitle, n.content AS ncontent, n.id AS nid, n.source AS nsource, n.time AS ntime, n.image AS nimage, u.id AS uid, u.name AS uname, u.surname AS usurname, COUNT(c.id) AS commentscount
FROM news AS n, users AS u
LEFT JOIN comments AS c ON (c.what='N' AND c.wid = n.id)
WHERE u.id = n.user
GROUP BY n.id
ORDER BY n.time DESC
[SQL] pobierz, plaintext 

#1054 - Unknown column 'n.id' in 'on clause'

Kiedyś miałem już podobny problem: http://forum.php.pl/index.php?showtopic=63...rt=#entry336520 i nie wiem w końcu co robię źle. :C

EDIT:

ok, got it

[SQL] pobierz, plaintext 
SELECT n.*, u.name AS uname, u.surname AS usurname, COUNT(c.id) AS commentscount
FROM news AS n
LEFT JOIN users AS u ON u.id = n.user
LEFT JOIN comments AS c ON (c.what='N' AND c.wid = n.id)
WHERE u.id = n.user AND n.nday = 1
GROUP BY n.id ORDER BY n.time DESC
[SQL] pobierz, plaintext 

Ten post edytował tommy4 19.08.2007, 14:12:01