Thanks for the reply, can you give me a example of how I can do this please.
On Wednesday, August 8, 2012 2:22:18 PM UTC-4, Daren W wrote: > > 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.
