[PHP]Users list

[cipcip]

A really simple php users list.

The code:

<?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!

 

[Eric]

Instead of

$letter = strtoupper(substr($list['user'],0,1));

You could also

$letter = strtoupper($list['user']{0});