Jump to content

SUM broke query


unemployment

Recommended Posts

I broke my query when I added in SUM.  Any idea why?

 

        $sql  = "(SELECT `users`.`firstname`, `users`.`lastname`, `users`.`accounttype`, SUM(`partners`.`approved`) FROM `partners` INNER JOIN `users`";
$sql .= " ON `partners`.`user_id` = `users`.`id` WHERE `partners`.`friend_id` = ${uid} AND `approved` = 1)";
$sql .= " UNION ALL ";
$sql .= "(SELECT `users`.`firstname`, `users`.`lastname`, `users`.`accounttype`, SUM(`partners`.`approved`) FROM `partners` INNER JOIN `users`";
$sql .= " ON `partners`.`friend_id` = `users`.`id` WHERE `partners`.`user_id` = ${uid} AND `approved` = 1)";

Link to comment
https://forums.phpfreaks.com/topic/227070-sum-broke-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.