Help with this SELECT statement

Help with this SELECT statement

10-16-2014, 11:21 PM

[eluser]jerry4christ[/eluser]
[quote author="rufnex" date="1413489548"]try with "as":

Code:
->select("SUM(IF(comments.is_active = 1,1,0)) as total_comments")

[/quote]

I've tried with as and still get the same error.

Messages In This Thread

Help with this SELECT statement - by El Forum - 10-16-2014, 11:36 AM

Help with this SELECT statement - by El Forum - 10-16-2014, 12:59 PM

Help with this SELECT statement - by El Forum - 10-16-2014, 11:21 PM

Help with this SELECT statement - by El Forum - 10-16-2014, 11:32 PM

Help with this SELECT statement - by El Forum - 10-17-2014, 02:15 AM

Help with this SELECT statement - by El Forum - 10-17-2014, 02:24 AM

Help with this SELECT statement - by El Forum - 10-17-2014, 02:30 AM

Help with this SELECT statement - by El Forum - 10-17-2014, 05:04 AM