Help With Cactivedataprovider

Yii 1.1 General Discussion
1

Hi all

I want use CActiveDataProvider with query below

$sql = "SELECT SD.Ph_ID,SUM(SD.Sales_Quan), P.Ph_Name, P.Price, P.Image

    FROM `sales_detail` AS SD, Phones AS P 


    WHERE SD.Ph_ID = P.Ph_ID 


    GROUP BY Ph_ID 


    ORDER BY SUM(Sales_Quan) DESC";

someone help me,thanks.

2

[color="#006400"]/* moved from Bug Discussions */[/color]