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();?>