getOne($sql);
if ($rows == 0) {
die('No members found.');
}
$sql = "SELECT id, username, name, email_priv, email FROM member $where ORDER BY username";
$mp = new MultiPage($db, uri_self(), $rows, $sql, 20, 'Members');
$result = $mp->getResult();
require_once 'HTML/Table.php';
$table = new HTML_Table('cellpadding="0" cellspacing="5"' .
'width="100%" summary="a list of all members"');
$table->addRow(array('Username', 'Name', 'Email'), null, 'TH');
while ($result->fetchInto($row)) {
if ($row->email_priv == 'y') {
$email = 'hidden';
} else {
$email = encodeEmail($row->email);
}
$row->username = '' . $row->username . '';
$table->addRow(array($row->username, $row->name, $email) );
}
echo '' . $mp->getHeader() . '
';
$table->display();
echo '' . $mp->getNav() . '
';
?>