PHP-Code:<?
$potdaten = db_query("SELECT js.*, u.nickname FROM vms_jackpotsystem_win AS js LEFT JOIN vms_userdaten AS u ON u.uid=js.uid WHERE js.beendet = '1' AND js.name = 'smallpot' ORDER BY js.Zeit DESC LIMIT 10");
while ($potliste=mysql_fetch_array($potdaten)) {
echo '
<tr>
<td align="center" width="33%" nowrap>'.date("d.m.Y H:i:s",$potliste['zeit']).'</td>
<td align="center" width="33%">'.$potliste['nickname'].'</td>
<td align="center" width="33%">'.number_format($potliste['win'],0,",",".").'</td>
</tr>
';
}
?>
Zitieren