alan dawson's blog

Used the taxonomy_access module to create public and private tags. Anonymous users can see the public tagged content but only registered users can see the private content.

plagiarised a quick php sql query to list all registered users and links to there profiles.

<?php

$header = array(
array('data' => t('Username'), 'field' => 'u.name', 'sort' => 'asc')
);
$sql = "SELECT u.uid, u.name FROM {users} u WHERE u.uid > 1";
$sql .= tablesort_sql($header);
$result = pager_query($sql, 50);

$status = array(t('blocked'), t('active'));
while ($account = db_fetch_object($result)) {