Monday, 21 August 2017

80.social engine where clause array with IN operator

 $resourceids=array();
   foreach($secondlevelData as $row){
array_push($resourceids,$row->resource_id);
   }

 
    $thirdlevel_friends_select = $membershipTable->select()
                      ->setIntegrityCheck(false)
                      ->from(array('membership'=>'engine4_user_membership',))
                      ->where('membership.resource_id IN (?)',$resourceids )
                               ->where('membership.active = ?',1 )
                      ->group('membership.user_id');    
    

No comments:

Post a Comment