Writing Multiple Select Query In Yii

Yii 1.1 General Discussion
1

Hi Experts,

I’m quite confused on how to write multiple select query in Yii…can anyone tell me how to write this in yii

my sql query


select * 

from movie 

where id in (

     select movie_id

     from movie_view

     where user_id in (

	  select id

	  from user

	  where id in (

		select user_id

		from movie_view

		where movie_id = 284

		)

	)

)

Many Thanks,

2

you can retrive CDbCommand sql by using it’s text method and use that sql as subquery in another sql

CDbCommand->text

3 



$connection=Yii::app()->db;

$sql = "

select * 

from movie 

where id in (

     select movie_id

     from movie_view

     where user_id in (

          select id

          from user

          where id in (

                select user_id

                from movie_view

                where movie_id = 284

                )

        )

)

";

$command = $connection->createCommand($sql);


$dataReader = $command->queryAll();

return $dataReader;
4

Sub queries have a place but I think this works:




$result = Yii::app()->db->createCommand()

  ->select('m.*')

  ->from('movie m')

  ->join('movie_view mv', 'm.id = mv.movie_id')

  ->join('user u', 'mv.user_id = u.id AND m.id = :movieId', array(':movieId' => 284))

  ->queryAll();

Cheers.

5

Thanks Fouss :)

Thanks luke jurgs and all :)

cheers!! :)

6

Thanks you for this treath … , Now may Problem has ben slove…