Help with this SELECT statement

Help with this SELECT statement

10-16-2014, 12:59 PM

[eluser]rufnex[/eluser]
try with "as":

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

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