How can I check the voting function of php?

I have a question about how php can handle the check box voting function. I have a check box form & lt; formactionmethodpostname & quot; form & quot; & gt; & lt; inputtype & quot; checkbox & quot; id & quot; sel & quot; name & quot; sel & quot; value php
I have a question for you.
I now have a checkbox form


The database is as follows:
Id name tic (number of votes)
1 basketball 0
2 Football 0
3 volleyball 0

What I want to achieve is that after the form is submitted, the tic number of votes in the database corresponding to the check box selected increases by 1.


------ Solution --------------------

PHP code

Foreach ($ _ POST ['Sport '] as $ id) {mysql_query ("update tt set tic = tic + 1 where id = $ id ");}