Quote Originally Posted by livemotion
I'm a little confused by the GROUP BY query, do i need to select all colums within it? I'm already using $result to define each one.

and would this be the correct way to set up the those queries:
SELECT B.id, B.timestamp, B.user, B.title, B.views, B.content, count( C.linkid ) AS comments
FROM journal_blog B
LEFT OUTER
JOIN journal_comment C ON B.id = C.linkid
GROUP BY B.id, B.timestamp, B.user, B.title, B.views, B.content
ORDER
BY B.id DESC
LIMIT 0 , 10

0 and 10 would be replaces with the variables pf course.
everything works except for the variable comments its always 0