How to count item stock

Need help Database
1

In trying to get the item count i.e. Sprite 30 left. Hope tht makes sense. How could I upon click subtract 1 from the count. I.e originally 30 is left but after 1 click now i got 29