تالار گفتمان nCIS.ir

$specialCategories = Categories::model()->findAll(array(
    'order' => 'RAND()',
    'limit' => 4,
    'condition' => 'special=1',
));

<?php

$specialCategories = Categories::model()->findAll('special=1 AND confirmed =1');

foreach($specialCategories AS $special ){
  
    $products=Products::model()->findAllByAttributes(array('category_id' => $special->id, 'confirmed' =>1),array('limit'=>4));
    
}

foreach(Categories::model()->findAll('special=1 AND confirmed =1') AS $special) {
    $products = Products::model()->findAll(array(
        'condition' => 'category_id=:categoryId AND confirmed=1',
        'params' => array(':categoryId' => $special->id),
        'limit' => 4,
    ));
}