x

Manyi Guo

x

List users

$rid = 3; $result = db_query("SELECT u.uid, u.name, u.status FROM {users} u INNER JOIN {users_roles} ur ON u.uid=ur.uid WHERE ur.rid = %d AND u.status = 1 ORDER BY u.name ASC", $rid); while ($u = db_fetch_object($result)) { $items[] = l($u->name, "user/" . $u->uid); } return theme('item_list', $items);
↑