Multiple Query with where

Yii 2.0 General Discussions
1

Hi there.

I am having trouble with multiple queries.

For example, I have ID numbers from 1 to 10, and I want to display IDs 2,3,4 in my ListView.


$searchmodel= new SearchUser;

$query = $searchmodel::find()->where(['id' => '2']);

If I use andWhere, it will only display the last id.




$query = $searchmodel::find()->where(['id' => '2'])->andWhere(['id' => '3'])->andWhere(['id' => '4']);

How should I query in this case?

Thank you.

[Resolved]




$query = $searchmodel::find()->where(['id' => [2,3,4]]);