db_query

---

SELECT COUNT(c.id) AS comments, n.id as newsid, n.title, n.news, n.allowcomments, 
                                           DATE_FORMAT(FROM_UNIXTIME(n.timeposted + (-3600 ) + (3600 * +0 )), '%d-%m-%Y %h:%i%p') as `date`, 
                                           DATE_FORMAT(FROM_UNIXTIME(n.timeposted + (-3600 ) + (3600 * +0 )),'%W %D %M, %Y') as dateGroup,
                                           u.postname, cat.name as catname, cat.avatar_name, cat.avatar_url
                                           FROM `satm26_news` as n, `satm26_users` as u
                                           LEFT JOIN `satm26_comments` as c ON (n.id = c.newsid)
                                           LEFT JOIN `satm26_category` as cat ON (cat.id = n.catid)
                                           WHERE n.userid = u.userid
                                           
                                           GROUP BY n.id
                                           ORDER BY n.timeposted DESC
                                           LIMIT 1
                                           

Unknown column 'n.id' in 'on clause'

Nothing entered yet...

Post your own - keep 'em brief!

name:

shout:

" "