1: 
2: 
3: 
4:

while($row = mysql_fetch_object($result))
{
  ...
}

1: 
2:

$result = mysql_query("SELECT * FROM mcspieler WHERE userid='$s'");
$row = mysql_fetch_object($result);