[eluser]FREEZA[/eluser]
How is the correct DB Syntax for Codeigniter?
Code:
SELECT u.uid, u.picture,
e.id, e.cat, e.headline, e.content, e.name, e.datum,
COUNT(c.id) AS anzahl_kommentare
FROM user u
INNER JOIN entry e ON ( e.uid = u.uid )
LEFT JOIN comment c ON ( c.e_id = e.id )
GROUP BY u.uid, u.picture,
e.id, e.cat, e.headline, e.content, e.name, e.datum
Width.. $this->db....