Last user registered on mainmenu?
214
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>';
$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>';
//link
echo ' <img src="linktoimage.png" alt="" /> The last: <a href="/users/profile.php?user='.$lastuser['id'].'">'.$lastuser['name'].'</a>';
sniper_uz
28 дек 2014 г., 20:29
SpAgEtE
28 дек 2014 г., 20:31
U tested? @sniper_uz ?
sniper_uz
28 дек 2014 г., 20:33
SpAgEtE
28 дек 2014 г., 20:35
Thanks man .gif)
tronixit_uz
28 дек 2014 г., 21:32
Assalomu alaykum do'stlar!
.бин. Qoders!
Всего: 8
© 2024, JohnCMS