- Impact
- 1,418
A really simple php users list.
The code:
Will output this:
Enjoy!
The code:
PHP:
<?php
$sql = "SELECT * FROM users ORDER BY user";
$res = mysql_query($sql);
if (mysql_num_rows($res)){
while ($list = mysql_fetch_array($res)) {
$letter = strtoupper(substr($list['user'],0,1));
if ($letter != $prev_row) {
echo "<br /><b><u>$letter</u></b><br />";
}
echo "<a href='#'>{$list['user']}</a> <br />";
$prev_row = $letter;
}
?>
Will output this:
Enjoy!