为每个个人资料/帐户添加综合浏览量

I'm trying to add a profile viewcount into mysql table and update it with php on refresh page or everytime someone visits their profile.

I'm using this code:

    $username = $_GET['user'];
$query = $connect->query("SELECT * FROM `users` WHERE `email` = '". $_SESSION['email'] ."'");
$u = $query->fetch_assoc();
$query = $connect->query("SELECT * FROM `users` WHERE `username` = '". $username ."'");
$r = $query->fetch_assoc();
$profile = $connect->query("SELECT * FROM `users.profiles` WHERE `user_id` = '". $r['id'] ."'");
$p = $profile->fetch_assoc();
$follows = $connect->query("SELECT * FROM `users.follows` WHERE `follow_id` = '". $r['id'] ."'");
$following = $connect->query("SELECT * FROM `users.follows` WHERE `user_id` = '". $u['id'] ."' AND `follow_id` = '". $r['id'] ."'");

//this is the count code

$viewc = $r['viewcount'] + 1;
$alterview = $connect->query("UPDATE `users.profiles` SET `viewcount` = '". $viewc ."' WHERE `id` = '". $p['id'] ."'");

I'm unsure where i'm going wrong, i need it to update +1 count in the viewcount column in the user.profiles table.

Any help will be greatly appreciated guys!

$viewc = $p['viewcount'] + 1; $alterview = $connect->query("UPDATE users.profiles SET viewcount = '". $viewc ."' WHERE id = '". $r['id'] ."'");

this worked, thanks all.