CakePHP - Paginate / Query: find lowest of multiple fields & order by it

Posted by Atea on Stack Overflow See other posts from Stack Overflow or by Atea
Published on 2010-04-05T15:30:21Z Indexed on 2010/04/05 15:33 UTC
Read the original article Hit count: 208

Filed under:

cakephp

|

paginate

|

mysql-query

I am using CakePHP for a price-comparison website.

I have a table products with fields: id, pride_regular, price_action.

I would like to combine the fields price_regular and price_action into a dynamic field: price. The lowest value of these two fields should be the value of the new price field. Also I want to order on it Ascending.

Should I use a custom MySQL-query?

© Stack Overflow or respective owner

Related posts about cakephp

Losing sessions with window.open and cakephp redirection in PHP with cakephp

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys, Ok, here goes a very strange problem... Our team is using cakephp to develop a large application. Everything session related is working properly so far. The only issues we've had so far are related to iframes and opening windows in other subdomains. I'll explain: User opens up site… >>> More
CakePHP sending multiple lines of same cookie information in response header. why??

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am having this problem with one of my cakePHP applications. My application displays a big html table on the page. I noticed that when the table goes beyond a certain size limit, IE cannot display that page. While trying to figure out why this happens, I noticed that my html response… >>> More
CakePHP: trouble configuring .htaccess for user directories enabled server

as seen on Server Fault - Search for 'Server Fault'
I've placed the CakePHP files in a directory in /home/user/public_html/cakephp. When I try to reach localhost/~user/cakephp with my browser, there's an error message. In my case, since I'm using Chrome, it is 'Oops! This link appears to be broken.". Looking for a solution on Google, I found a few… >>> More
CakePHP: 2-level JOIN with one Query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following models in CakePHP: A Deposit belongs to an Account An Account belongs to a Customer I want to have a list of Deposits, and I need to show the name of the customer (so I have to join through the Customer). I also need to paginate this list. If I set Deposit->recursive = 2… >>> More
[CakePHP] Can not Bake table model, controller and view

as seen on Stack Overflow - Search for 'Stack Overflow'
I developed small CakePHP application, and now I want to add one more table (in fact, model/controller/view) into system, named notes. I had already created a table of course. But when I run command cake bake model, I do not get table Notes on the list. I can add it manually, but after that I get… >>> More

Related posts about paginate

Jquery Cycle: How Can I Paginate the Pager?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am using the Jquery cycle plug in with the pager. I have a lot of items to page through. Is there a way I can add back and previous arrows to paginate the pager? So I have like: 1 2 3 4 5 6 7 8 9 and I want the same but < 1 2 3 4 5 6 7 8 9 Is there an elegant… >>> More
cakephp paginate using mysql SQL_CALC_FOUND_ROWS

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to make Cakephp paginate take advantage of the SQL_CALC_FOUND_ROWS feature in mysql to return a count of total rows while using LIMIT. Hopefully, this can eliminate the double query of paginateCount(), then paginate(). http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows I've… >>> More
will paginate, nested routes, ruby, rails

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to get will paginate to link to my nested route instead of the regular posts variable. I know I'm supposed to pass some params to paginate but I don't know how to pass them. Basically there is an array stored in @posts and the other param paginate has access to is category_id. The nested… >>> More
will_paginate with named_scopes

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using will_paginate for pagination, which has been working well so far, except for this one thing. If I try to paginate a scope, for instance class User < ActiveRecord::Base named_scope :scope, lambda { etc } end User.scope.paginate({:page => params[:page], :per_page => 10}) That… >>> More
Filter, sort and paginate in Codeigniter

as seen on Stack Overflow - Search for 'Stack Overflow'
Ive recently started using CodeIgniter as I was searching for a very lightweight framework and it seemed to come up as a top choice. I am new to the whole MVC thing, enjoying it but am stuck with something which seems very simple. I am coding a CMS and need a way to filter, sort and paginate the… >>> More