[SQL] pobierz, plaintext 
  1. 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
  2. FROM news AS n, users AS u
  3. LEFT JOIN comments AS c ON (c.what='N' AND c.wid = n.id)
  4. WHERE u.id = n.user
  5. GROUP BY n.id
  6. 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 
  1. SELECT n.*, u.name AS uname, u.surname AS usurname, COUNT(c.id) AS commentscount
  2. FROM news AS n
  3. LEFT JOIN users AS u ON u.id = n.user
  4. LEFT JOIN comments AS c ON (c.what='N' AND c.wid = n.id)
  5. WHERE u.id = n.user AND n.nday = 1
  6. GROUP BY n.id ORDER BY n.time DESC
[SQL] pobierz, plaintext