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 User is offline   Rajesh_7186 

  • Newbie
  • Yii
  • 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
0

#2 User is offline   kokomo 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 289
  • 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.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users