It works fine, but

[D-flyer]

there must be a better way. I am a php-newbie:
[php]
$numOfAvatars = mysql_num_rows($result);

echo "$numOfAvatars";
$i=0;
IF($numOfAvatars==0){
echo "&status=" .urlencode("No others have been found");
}ELSEIF($numOfAvatars>0){
echo "&status=$numOfAvatars others have been found";
WHILE($i<$numOfAvatars) {
$userName=mysql_result($result,$i,"userName");
// display avatar names
echo "&userName$i=$userName";
$i++;
}
}

[/code]

All i want is to get a output in this form:
&userName0=a&userName1=b&userName2=c&userName3=d etc.

I don't like my use of $userName=mysql_result($result,$i,"userName");

Any suggetions?

[cupid]

Mysql_fetch_* are functions designed for multiple fetches like what you're doing.

/* top code snipped */
elseif ($numOfAvatars>0) {
        echo "&status=$numOfAvatars others have been found";

        while ($user = mysql_fetch_array($result))
                echo "&userName$i=$user[userName]";
} 

[D-flyer]

thx cupid,

going to check the mysql_fetch_array function at mysql.org

your code works like a charm

//Grtz

[cupid]

Great! By the way.. mysql_fetch_array is a PHP function. You'd get better documentation on php.net