13
here is my final code:
le="color: #000000"><?php 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!
