changed order by, now this

[Velocd]

Hmm, I thought that was correct syntax.

Perhaps try COUNT(journal_comments.title) (or a field in journal_comments) instead.

[AN-net]

ok i changed it but now i get illegal sql query cause of no group bys

Originally Posted by mysql

Invalid SQL:
SELECT journal_entries.entry_id, journal_entries.entrytitle,
journal_entries.entrytext, journal_entries.entrydate,
journal_entries.entry_totalvotes, journal_entries.entry_totalrating,
journal_entries.private, journal_entries.whocanview,
COUNT(journal_comments.comment_text) AS comments
FROM journal_entries
LEFT JOIN journal_comments
USING (journal_id)
WHERE journal_entries.journal_id='6'
AND entry_active='1'
ORDER BY entrydate ASC

mysql error: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause

[AN-net]

bump!

[AN-net]

anyone?