Welcome Guest, Not a member yet? Register   Sign In
[solved] Comment Counting Again
#4

[eluser]darkhouse[/eluser]
Ah, I think all that was required was to add FALSE into the select method, like this:

Code:
$this->db->select('e.*, COUNT(c.entry_ID) AS total_comments', FALSE);

Active Record was putting backquotes in where it shouldn't have, setting that 2nd parameter to FALSE makes it not do that. I should've known, my bad.


Messages In This Thread
[solved] Comment Counting Again - by El Forum - 02-18-2009, 05:03 PM
[solved] Comment Counting Again - by El Forum - 02-19-2009, 02:14 AM
[solved] Comment Counting Again - by El Forum - 02-19-2009, 09:08 AM
[solved] Comment Counting Again - by El Forum - 02-19-2009, 07:18 PM



Theme © iAndrew 2016 - Forum software by © MyBB