show query result

[koukiya (Kaoutar Bf)]

hello, i’m a new member, i wonder if there is someone who can help me please

i have two tables user(iduser,loginu, pass) and resultsglobal(iduser,date) , i want to execute this query and show the results in CGridview

select u.loginu as login , count(*) as cr

			from 


			resultsglobal as r , user as u


			where


			r.iduser = u.iduser


			group by u.loginu

login | cr

---

jean 34222

christine 42343132

how can i show the result returned by a select query in my CGridview??

thaannx

[Wartex]

hi!

in your controller:

$sql='select u.loginu as login , count(*) as cr

from

resultsglobal as r , user as u

where

r.iduser = u.iduser

group by u.loginu’;

$dataProvider=new CSqlDataProvider($sql, array());

$this->render(‘view’, array(‘dataProvider’=>$dataProvider));

in your view:

$this->widget(‘zii.widgets.grid.CGridView’, array(

'dataProvider'=>$dataProvider,

));

i dont have try this lines… but i think u understand what i want to say

[koukiya (Kaoutar Bf)]

thank you,

i’ve resolved it using $criteria

$criteria=new CDbCriteria;

           $criteria->select='t.loginu , count(*) as clicks';


	


	$criteria->join= 'JOIN resultsglobal ON t.idutilisateur= resultsglobal.idutilisateur';


	$criteria->condition="t.idutilisateur = resultsglobal.idutilisateur ";


	$criteria->group='loginu';