ChristianAlfred
11-20-2007, 11:02 AM
I have the following code to get the latest blog for my frontpage. How can I display the avatar for the user?
$query_blog = mysql_query("SELECT blogid, userid, username, title, lastblogtextid, dateline FROM vb3_blog ORDER BY lastblogtextid DESC LIMIT 1") or exit(mysql_error());
echo "<a href='/forum/blog.php?b=" . $rs_blog["blogid"] . "'>" . $rs_blog["title"] . "</a> <a href='http://www.zoopet.com/forum/member.php?u=" . $rs_blog["userid"] . "'><small>(" . $rs_blog["username"] . ")</small></a><br>";
$query_blog = mysql_query("SELECT blogid, userid, username, title, lastblogtextid, dateline FROM vb3_blog ORDER BY lastblogtextid DESC LIMIT 1") or exit(mysql_error());
echo "<a href='/forum/blog.php?b=" . $rs_blog["blogid"] . "'>" . $rs_blog["title"] . "</a> <a href='http://www.zoopet.com/forum/member.php?u=" . $rs_blog["userid"] . "'><small>(" . $rs_blog["username"] . ")</small></a><br>";