Hall of fame

{source}
<?php
if ($_SERVER['DOCUMENT_ROOT']=="C:/xampp/htdocs") {
include $_SERVER['DOCUMENT_ROOT']. "/unstest/includes/unsvar.php";
$pfad = "/unstest/images/comprofiler/";
}
Else {
include $_SERVER['DOCUMENT_ROOT']."/includes/unsvar.php";
$pfad = "/images/comprofiler/";
}

$mysqli = new mysqli($dbhost, $dbusername, $dbpassword, $dbname);
if ($mysqli -> connect_error) {
echo "Fehler bei Verbindung: " . mysqli_connect_error();
exit();
}
if (!$mysqli -> set_charset("utf8")) {
echo "Fehler beim Laden von UTF8 " . $mysqli -> error;
}

$ergebnis = $mysqli -> query("SELECT
avatar,
lastname,
firstname,
cb_ehrenmitglied,
cb_ehrengrund

FROM
unsw_comprofiler

WHERE
cb_ehrenmitglied = 1

ORDER BY lastname, firstname");

echo "<table style='width: 100%';>
<tbody>
<tr>
<th></th>
<th>Nachname</th>
<th>Vorname</th>
<th>Grund</th>
</tr>";

while ($ausgabe = $ergebnis -> fetch_array()) {

echo "<tr>
<td><a href='" . $pfad . $ausgabe['avatar'] . "' target='_blank' data-mediabox='caption[" . $ausgabe['firstname'] . $ausgabe['lastname'] . "];group[uns]' class='jcepopup'><img style='width: 40px; margin: 5px; border: 1px solid #000000; vertical-align: top;' src='" . $pfad . "tn" . $ausgabe['avatar'] . "' alt='" . $ausgabe['avatar'] . "' /></a></td>
<td>" . $ausgabe['lastname'] . "</td>
<td>" . $ausgabe['firstname'] . "</td>
<td>" . $ausgabe['cb_ehrengrund'] . "</td>
</tr>";
}

$ergebnis -> close();
$mysqli -> close();
echo "</tbody>
</table>";
?>
{/source}