php - cakephp pagination with complex query -

-

i have database structure given below

id | title   | brand |  ---+---------+-------+ 1  |product1 | lg    | 2  |pruduct2 | lg    | 3  |pruduct3 | lg    | 4  |pruduct4 | lg    | 5  |pruduct5 | lg    | 6  |pruduct6 |samsung| 7  |pruduct7 |samsung| 8  |pruduct8 |samsung| 9  |pruduct9 |samsung| 10 |pruduct10|samsung| 11 |pruduct11| sony  | 12 |pruduct12| sony  | 13 |pruduct13| sony  | 14 |pruduct14| sony  | 15 |pruduct15| sony  |

we need query can mix results brands
output should like

id | title   | brand |  ---+---------+-------+ 1  |product1 | lg    | 6  |pruduct6 |samsung| 11 |pruduct11| sony  | 2  |pruduct2 | lg    | 7  |pruduct7 |samsung|     12 |pruduct12| sony  | .... , on

i have following query can retrieve same result

select id, title,brand row_number() on (partition brand_id)  row_num product_test order row_;

this doesn't work mysql unfortunately need solution based on cakephp find or other apporach

thanks in advance

you can emulate query in following way:

select @rownum := 0, @brand := null;  select   id , title , brand (   select     id   , title   , brand   , @rownum := if(@brand <=> brand, @rownum + 1, 1) row_num   , @brand := brand dummy       product_test   order     brand   , id   ) product_test order   row_num , brand , id;

Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5); ...
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:...
Read more