Hi frieds,i need code to show last pitcures of users on main menu
How much users show on main menu?
Да не юзеров отобразить, а последнюю картинку.
ok.
show random fhotos of user's album
Put this code on end.php
echo'<div class="footer"><b>Random Photo</b></div>';
$hammad4=mysql_query("SELECT `id`, `user_id`, `tmb_name`, `time` FROM `cms_album_files` order by rand() limit 1 ")
$ar34=mysql_fetch_array($hammad4);
echo'<div class="list2"><img src="../files/users/album/'.$ar34['user_id'] .'/'.$ar34['tmb_name'] .'" alt="'.$ar34['id'] .'"/> ';
print'<a href="../users/profile.php?user='.$ar34['user_id'] .'">Visit Profile</a><br/>
Enjoy!
pakalika (27.05.2011/14:00)
Put this code on end.php
[php]
echo'<div class="footer"><b>Random Photo</b></div>';
$hammad4=mysql_query("SELECT `id`, `user_id`, `tmb_name`, `time` FROM `cms_album_files` order by rand() limit
Not work.[php]order by rand() limit 1 ")
;
print'<a href="../users/profile.php?user='.$ar34['user_id'] .'">Visit Profile</a>
'; /php]