@import "http://lib.zetabin.com/jQuery/facebox/facebox.css";
|
Display the 5 newest users with avatar
|
|
Topic Started: Mar 6 2009, 02:25 PM (95 Views)
|
|
php-coder
|
Mar 6 2009, 02:25 PM
Post #1
|
|
- Posts:
- 134
- Group:
- Contributor
- Member
- #39
- Joined:
- Dec 8, 2008
|
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>";
|
|
|
| |
| 1 user reading this topic (1 Guest and 0 Anonymous)
|