Просмотр поста

//this is Mysql quetion
$lastuser = mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `preg` = 1 ORDER BY `datereg` DESC LIMIT 1"));

//link
echo ' <img src="linktoimage.png" alt="" /> The last: <a href="/users/profile.php?user='.$lastuser['id'].'">'.$lastuser['name'].'</a>';