Welcome Guest [Log In] [Register]
Add Reply
Display the 5 newest users with avatar
Topic Started: Mar 6 2009, 02:25 PM (95 Views)
php-coder
Member Avatar

Use this to display your 5 newest users, keep in mind you need to add the signupdate addon before this will work.


Code:
 

$query = "SELECT * FROM users ORDER BY signupdate DESC LIMIT 5";
$results = mysql_query($query) or die(mysql_error());
while ($value = mysql_fetch_array($results)) {
echo "<table border='0'>";
echo "<td>";
echo "<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER>";
echo "<TR>";
echo "<TD HEIGHT=3 COLSPAN=3 BACKGROUND='image.jpg'>";
echo "</TD>";
echo "</TR>";
echo "<TR>";
echo "<TD WIDTH=3 BACKGROUND='image.jpg'>";
echo "</TD>";
echo "<td width=80 height=80 align=center><img src='include/avatar/" . $value['username'] . "/" . $value['avatar'] . "' width='80' height='80'/>";
echo "<TD WIDTH=3 BACKGROUND='image.jpg'>";
echo "</TD>";
echo "</TR>";
echo "<TD HEIGHT=3 COLSPAN=3 BACKGROUND='image.jpg'>";
echo "</TD>";
echo "</TR>";
echo "</TABLE>";
echo "</td>";
echo "<td>";
echo "<center><a href='userinfo.php?user=" . $value['username'] . "'>" . $value['username'] . "</a></center>  Short user description here<br>  Sign up date here?<br>  last seen here?";
echo "</TD>";
echo "</TR>";
echo "</TABLE>";
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Other · Next Topic »
Add Reply