13
here is my final code:
global $xoopsDB;
$sql = "SELECT u.uid, u.uname, u.user_avatar, p.source_language, p.target_language, p.welcome FROM ".$xoopsDB->prefix("users")." u, ".$xoopsDB->prefix("groups_users_link")." g, ".$xoopsDB->prefix("profile_profile")." p WHERE u.uid = g.uid AND u.uid = p.profile_id AND g.groupid = 6 AND u.level > 0 AND u.uid NOT IN (1) ORDER BY RAND()";
$result = $xoopsDB->query($sql, 5);
while (list($uid, $uname, $user_avatar, $source_language, $target_language, $welcome) = $xoopsDB->fetchRow($result))
{
$user_avatar = ($user_avatar != 'blank.gif') ? $user_avatar : 'default_avatar.png'; // default_avatar.png - ????????? ??????
echo '<img src="' . XOOPS_URL . '/uploads/' . $user_avatar . '" alt="Avatar" width="50" height="50" /><br><a href="' . XOOPS_URL . '/userinfo.php?uid=' . $uid . '">' . $uname . '</a><br>' . $source_language . ' ยป <br>' . $target_language . '';
}
thanks guys. but i have one more thing. the code above shows 5 users. but it shows them in a column. how do i show them in a line? like 1-2-3-4-5
not
1
2
3
4
5
thanks in advance!