I am in the learning process and would like to know how to write the two below statements in cake format, could someone please advise.
SELECT SUM(credit) - SUM(debit) AS total FROM `bids` AS `Bid` WHERE `Bid`.`user_id` = 3 LIMIT 1 SELECT SUM(bids) AS total FROM `bidbutlers` AS `Bidbutler` LEFT JOIN `auctions` AS `Auction` ON (`Bidbutler`.`auction_id` = `Auction`.`id`) WHERE `Auction`.`closed` = 0 AND `Bidbutler`.`user_id` = 3 Thanks, Daren -- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
