<?php

require 'db.inc';

$mysqli = new mysqli($hostName, $userName, $password);

$mysqli->select_db('residential');

$mysqli->query("LOCK TABLES country WRITE");

$mysqli->query("UPDATE country SET population = population + 1
                WHERE id = {$_GET["country"]}");
		
$mysqli->query("UNLOCK TABLES");

$mysqli->close();

header("Location: update2.php5");
exit;
?>