4
ok i got this one working for me
global $xoopsDB;
$sql = "SELECT uid, uname, user_avatar FROM ".$xoopsDB->prefix("users")." WHERE level > 0 AND uid NOT IN (1) AND user_avatar <> 'blank.gif' ORDER BY RAND() LIMIT 10";
$result = $xoopsDB->query($sql);
while (list($uid, $uname,$user_avatar) = $xoopsDB->fetchRow($result) )
{
echo "
";
echo "
".$uname."";
}