Demos · Guide · Class Reference · Wiki · Extensions · Live Chat

Yii Framework Forum: mysql select query function on yii cactivedataprovider? - Yii Framework Forum

Jump to content

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

mysql select query function on yii cactivedataprovider? Rate Topic:

#1 Rajesh_7186

Newbie

Group: Members
Posts: 1
Joined: 02-February 12

Posted 16 February 2012 - 05:00 AM

how to use select query with mysql function like count , max ,min
,DISTICT with CActivedataproviders

currently not working on my project.

i try this on my project query. it display data properly but
in query "COUNT(tour_code) as tot" is not any output display

not display info about (tot , tour_code) in query output.

Please help me in this issue.

Thanks

#2 kokomo

Standard Member

Group: Members
Posts: 281
Joined: 23-July 10

Posted 17 February 2012 - 08:31 AM

This post should solve your problem.

For more information on doing e.g. count, max, min queries with yii read the section Statistical Queries of the topic Working with Databases: Relational Active Record in the guide.