PHP Code:
<?php
$mysql_host = '5.*.*.100';
$mysql_user = 'root';
$mysql_pass = '';
$anzahl_gms = '4'; //Wie viele GM's halt XD wie hier im Beispiel 4 GM's ^-^
$mysql_db = 'player';
//---------------------------------//
$conn = mysqli_connect($mysql_host, $mysql_user, $mysql_pass);
if ($conn) {
mysqli_select_db($conn, $mysql_db);
} else {
die('Error');
}
$i = 0;
$sql = "SELECT ´name´,´exp´,´level´ FROM player ORDER BY ´level´ LIMIT {$anzahl_gms},50";
$result = mysqli_query($conn, $sql);
?>
<table>
<tr>
<td>Rang</td>
<td>Name</td>
<td>Level</td>
<td>EXP</td>
</tr>
<?php
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $row['name']; ?></td>
<td><?php echo $row['level']; ?></td>
<td><?php echo $row['exp']; ?></td>
</tr>
<?php
$i++;
}
?>
</table>
]
