Нужно узнать id и вставить это значение в таблицу where id равен id который мы узнали

$url = ((!empty($_SERVER['HTTPS'])) ? 'https' : 'http') . '://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
$url = urldecode($url);
$id_r = "SELECT `id` FROM `page` WHERE `url` = $url";

$id_r_res = mysqli_query($conn, $id_r);
$sql = "UPDATE `page` SET `hit` = `hit` + 1 WHERE `page`.`id` = '$id_r_res'";
$result = mysqli_query( $conn, $sql ) ;
if (mysqli_affected_rows($conn) != 1)
    { echo '<p>Ошибка</p>'.mysqli_error($conn);
    }

$url = ((!empty($_SERVER['HTTPS'])) ? 'https' : 'http') . '://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
$url = urldecode($url);
$id_r = "SELECT `id` FROM `page` WHERE `url` = $url";
$id_r_res = mysqli_query($conn, $id_r);
$sql = "UPDATE `page` SET `hit` = `hit` + 1 WHERE `page`.`id` = '$id_r_res'";
$result = mysqli_query( $conn, $sql ) ;
if (mysqli_affected_rows($conn) != 1)
    { echo '<p>Ошибка</p>'.mysqli_error($conn);
    }

$sql = "INSERT INTO `refferer` (`id_page`,`url_page`,`ip`,`reff`,`os`,`date`,`browser`) VALUES (1,'$url','$ip', '$reff','$os',NOW(),'$browser' )" ;
$result = mysqli_query( $conn, $sql ) ;
if (mysqli_affected_rows($conn) != 1)
    { echo '<p>Ошибка</p>'.mysqli_error($conn);
    }