Update profile views

[JackCode]

Hi, basically I want a dynamic hit counter every time someone views someone else's profile. Here is my code:

 

<?php

 

$req = mysql_query('select hits from users where username="'.$username.'"');

$dn = mysql_fetch_array($req);

 

$update = mysql_query('UPDATE users SET hits = hits + 1 WHERE username="'.$username.'"');

 

 

echo "Profile views: ".$dn['hits'];

 

 

?>

 

It returns the value in the database but does not update it dynamically unless I change it myself in the database. 

[JackCode]

Fixed.