• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help with this SELECT statement

#5
[eluser]jerry4christ[/eluser]
[quote author="rufnex" date="1413527527"]Sorry as is not relevant here (was late on yesterday ;o)
Try to set ' in your condition:

Code:
->select("SUM(IF(comments.is_active = '1',1,0)) total_comments")
[/quote]



Code:
A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`total_comments`, `default_users`.`username`, `default_profiles`.`display_name` ' at line 1

SELECT `default_blog`.*, `default_blog_categories`.`title` AS `category_title`, `default_blog_categories`.`slug` AS `category_slug`, SUM(IF(comments.is_active = '1', 1, `0))` `total_comments`, `default_users`.`username`, `default_profiles`.`display_name` FROM `default_blog` LEFT JOIN `default_blog_categories` ON `default_blog`.`category_id` = `default_blog_categories`.`id` LEFT JOIN `default_comments` ON `default_comments`.`entry_id` = `default_blog`.`id` LEFT JOIN `default_profiles` ON `default_profiles`.`user_id` = `default_blog`.`author_id` LEFT JOIN `default_users` ON `default_blog`.`author_id` = `default_users`.`id` WHERE `status` = 'live' AND `default_blog`.`created_on` <= 1413529819 ORDER BY `created_on` DESC LIMIT 100


Same result. don't know why this is showing up `0))`


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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.