Languages
Feeds in the planet
English
Spanish
Nederlands
Japanese
Português
Czech
Deutsch
Order By Sum of Two Fields
Submitted by Derick Ng on 21 August 2009 - 6:36am
Let's say I have a table with karma_up and karma_down. Everytime someone votes up karma_up gets incremented and everytime someone votes down karma_down gets incremented one as well. How can I pull these a selection of rows and have them ordered by the sum of these new values? ORDER BY (karma_up - karma_down) does not seem to work how I want. I simply want the rows with the highest karma up top.
Similar entries
- Pagination with hasMany association cakePHP
- using cakephp, how do I display a series of data without using for each loops?
- Limiting rows in CakePHP
- Conditions in associated models using Model->find() (CakePHP)
- CakePHP: find neighbors, order on 'name' or 'order'
- How to Query inside foreach loop which returns morethan one row foreach () + cakephp
- VBScript and Oracle, Redux
- How to pre-populate a saveAll form?
- How Do You Rate?
- Insert rows in a loop in CakePHP
Popular content
Today's:
All time:
