$sql = "SELECT COUNT(*),id,login,name FROM users WHERE login='$login' AND password ='$password'";
    $result = mysql_query($sql) or die (mysql_error());
    	if (mysql_result($result,0)>0){
        $arr = array();
        while ($row=mysql_fetch_assoc($result)){
          $arr[]=$row;
        }
        foreach ($arr as $item){
                $_SESSION['id'] = $item['id'];
                $_SESSION['login'] = $item['login'];
                $_SESSION['password'] = $item['password'];
                $_SESSION['name'] = $item['name'];
        }   
        echo $_SESSION['name'];