<?php
include("resources/scripts/functions.php");

echo "Userliste:<br><br>";

$sql = mysql_query("SELECT * FROM user ORDER by username");
$row = mysql_fetch_array($sql) or die(mysql_error());
$oldFirstChar = "";
while($row = mysql_fetch_assoc($sql)) {

$string = $row["username"];

$firstChar = strtoupper($string[0]);

if($firstChar != $oldFirstChar) {
    echo $firstChar."<br/>";
    $oldFirstChar = $firstChar;
}
echo '<div id="members"><img src="../uploads/pictures/'.picture($string).'" width="200px" /></div>'.$row["username"]."<br>";
}
?>