PHP-Code:
<?head("Der neuste User ist...");?>
<?$query = mysql_fetch_array(db_query("SELECT u.*,w.* FROM ".$db_prefix."_userdaten AS ud
LEFT JOIN ".$db_prefix."_werberdaten AS w ON u.uid=w.uid
ORDER BY u.angemeldet_seit DESC LIMIT 1"));
?>
<table border="0">
<tr>
<td><b>Nick:</b></td>
<td><?=$query[nickname]?></td>
</tr>
<tr>
<td>Id:</td>
<td><?=$query[uid]?></td>
</tr>
<tr>
<td>Seit:</td>
<td><?=date("d.m.Y H:i",$query[angemeldet_seit]?></td>
</tr>
<tr>
<td>Werber:</td>
<td><?=$query[werber]?></td>
</tr>
</table>
';
}
</span>
<?<?foot();?>