how to limit uploads to X amount per user

What i am trying to do is give someone a limit for uploads, for example limit that person to 1000 uploads what do i do in combination with mysql or something else that adds on 1 everytime they make an upload until they reach the max of 1000

 

mysql_query("select limit from user_table where username_field='$username'");
//$username is whatever unique field you use to differentiate each user
//$limit is your mysql_fetch_assoc
if($limit>=1000){
print "too many uploads";
}else{
//uploading whatever you are uploading message
//uploading script here as well
mysql_query("update user_table set limit=limit+'1' where username_field='$username'");

}

PHP:

hope i helped.