<?php
mysql_select_db($mysql_db) OR
die("Die Datenbank konnte nicht benutzt werden.<br /> Fehlermeldung: ".mysql_error());
$sq2 = "SELECT
*
FROM
player
ORDER BY level DESC";
$ergebnis = mysql_query($sq2);
while($row = mysql_fetch_assoc($ergebnis)) {
$i = 1;
$name = $row['name'];
$name2 = substr($name, 0, 4);
$name3 = substr($name, 0, 5);
if ($name2 == "[GM]") { echo ""; } elseif ($name2 == "[GA]") { echo ""; } elseif ($name2 == "[SGM]") { echo ""; } else { echo "
<tr>
<td><font color=red>",$i,"</font></td>
<td><font color=blue>",$row['name'],"</font></td>
<td><font color=red>",$row['level'],"</font></td>
</tr>";
$i++;
}
}
?>
Ohne GM's.