Last user registered on mainmenu?

Последняя активность

Файлы топика

390

SpAgEtE

28 дек 2014 г., 12:22

Anyone have working code?

sniper_uz

28 дек 2014 г., 20:07

Изменено

//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>';

Fublin

28 дек 2014 г., 20:22

$lastuser = mysql_fetch_assoc(mysql_query("SELECT `id`, `name` FROM `users` ORDER BY id DESC LIMIT 1"));

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