$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';
$db = 'ThesisDB';

$conn = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($db);

$query = "SELECT * FROM AdrCheck";
$result = mysql_query($query);
while($address = mysql_fetch_assoc($result)){
    $searchTerm = $address['AdrName'];
    $addressId = $address['vID'];
    //download the json
    $apidata = file_get_contents('http://dawa.aws.dk/adresser/autocomplete?q=' . urlencode($searchTerm));

    $sql = "UPDATE AdrCheck SET status='$apidata' WHERE vID='$searchTerm'";
    $retval = mysql_query($sql, $conn);
    if (!$retval) {
        die('Could not update data: ' . mysql_error());
    }
    echo "Updated data successfully\n";
    mysql_close($conn);
    //if you want to access the data, you can use json_decode:
    $data = json_decode($apidata);
    echo $data[0]->tekst; //outputs Dornen 2, Tarp, 6715 Esbjerg N
}