PDO udlæsning af flere variable

Kode 

CREATE TABLE `members` (
  `id` char(23) NOT NULL,
  `username` varchar(65) NOT NULL DEFAULT '',
  `password` varchar(65) NOT NULL DEFAULT '',
  `email` varchar(65) NOT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT '0',
  `location` varchar(65) NOT NULL, 
  `mod_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username_UNIQUE` (`username`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `email_UNIQUE` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Kode 

public function checkLogin($myusername, $mypassword)
{
	$conf = new GlobalConf;
	$ip_address = $conf->ip_address;
	$login_timeout = $conf->login_timeout;
	$max_attempts = $conf->max_attempts;
	$timeout_minutes = $conf->timeout_minutes;
	$attcheck = checkAttempts($myusername);
	$curr_attempts = $attcheck['attempts'];

	$datetimeNow = date("Y-m-d H:i:s");
	$oldTime = strtotime($attcheck['lastlogin']);
	$newTime = strtotime($datetimeNow);
	$timeDiff = $newTime - $oldTime;

	try {

		$db = new DbConn;
		$tbl_members = $db->tbl_members;
		$err = '';

	} catch (PDOException $e) {

		$err = "Error: " . $e->getMessage();

	}
	
	$stmt = $db->conn->prepare("SELECT * FROM ".$tbl_members." WHERE username = :myusername);
	$stmt->bindParam(':myusername', $myusername);
	
	$stmt->execute();

	// Gets query result
	$result = $stmt->fetch(PDO::FETCH_ASSOC);
	
	echo $result['location']; // test <-----
	
	if ($curr_attempts >= $max_attempts && $timeDiff < $login_timeout) {

		//Too many failed attempts
		$success = "<div class=\"alert alert-danger alert-dismissable\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>Maximum number of login attempts exceeded... please wait ".$timeout_minutes." minutes before logging in again</div>";

	} else {

		 //If max attempts not exceeded, continue
		// Checks password entered against db password hash
		if (password_verify($mypassword, $result['password']) && $result['verified'] == '1') {

			//Success! Register $myusername, $mypassword and return "true"
			$success = 'true';
				session_start();

				$_SESSION['username'] = $myusername;

		} elseif (password_verify($mypassword, $result['password']) && $result['verified'] == '0') {

			//Account not yet verified
			$success = "<div class=\"alert alert-danger alert-dismissable\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>Your account has been created, but you cannot log in until it has been verified</div>";

		} else {

			//Wrong username or password
			$success = "<div class=\"alert alert-danger alert-dismissable\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>Wrong Username or Password</div>";

		}
	}
	return $success;
}

Kode 

// laver en liste af postnummer med et givent bynavn
public function GetPostNoList($cityname){
	$data = array();		
	$sql = "select Postnr from tbl_postnummer where Bynavn= :bynavn";
	// $sql = "select * from tbl_postnummer where Bynavn= :bynavn";
	if ($stmt = $this->conn->prepare($sql)){			
		/* Bind parametre */
		$stmt->bindParam(':bynavn', $cityname, PDO::PARAM_STR);	
		/* Eksekver forespørgslen */
		$stmt->execute();			
		/* Hent rækker og udskriv rækkerne i data arrayet */			
		while( $row = $stmt->fetch(PDO::FETCH_ASSOC)){ 
			$data[]=$row['Postnr'];
			
			// $data[]=$row; 
			// her kunne jeg udskrive flere collonner hvis de var selected 			
			/*
				echo $row['Postnr'] . "<br>" ;
				echo $row['Land'] . "<br>" ;
				echo $row['Bynavn'] . "<br>" ;
				... og evt andre felter der er i rækken
			*/
		}
	}
	else {
		/* Der er opstået en fejl */
		echo 'Der opstod en fejl i erklæringen: ' . $this->conn->error;
	}		
	return $data;
}

// henter bynavnet, der svare til postnummeret (no) i danmark
public function GetCityName($no, $country=1){	   
   $name = "unknown";		
	$sql = "select Bynavn from tbl_postnummer where Postnr = :postnr and Land = :land";  	
	// http://php.net/manual/en/pdostatement.bindparam.php	
	if ($stmt = $this->conn->prepare($sql)){
		// Bind parametre 
		$stmt->bindParam(':postnr', $no, PDO::PARAM_STR);
		$stmt->bindParam(':land', $country, PDO::PARAM_INT);
		// Eksekver forespørgslen
		$stmt->execute();				
		// Hent rækker og udskriv data 
		if ($row = $stmt->fetch(PDO::FETCH_ASSOC)){ 
			$name = $row['Bynavn'];	
		}		
	}		
	else {
		/* Der er opstået en fejl */
		echo 'Der opstod en fejl i erklæringen: ' . $this->conn->error;
	}
	return $name;	   
}

Kode 

CREATE TABLE `tbl_postnummer` (
  `Postnr` varchar(4) CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
  `Bynavn` varchar(25) CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
  `Gade` varchar(33) CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
  `Firma` varchar(58) CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
  `Provins` varchar(6) CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
  `Land` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;