$query = db_select('users', 'u'); $query -> join('users_roles', 'r', 'u.uid = r.uid'); $query -> fields('u',array('uid','name')); $query -> fields('r',array('rid')); $query -> condition('r.rid', 4,'='); $records = $query->execute(); $list['all'] = t(t('All')); foreach ($records AS $record) { $list[$record -> uid] = $record -> name; } return $list;
Categories: