configure mysql database to save progress
<p>I am new in forum, and need some help to do one functionality for my unity game. I am trying to save the progress of the player in one mysql database, like this:</p>

<pre><code>userid level stars
29     1     2
29     2     1
45     1     3
50     1     2
50     2     3
50     3     1
29     3     3
</code></pre>

<p>so the script send the userid provided by the user registration in the begining of the game. and for each level he complete, the script send the number of the level, and the amount of stars collected in the level.. </p>

<p>the problem and question is, how I configure this in the php script and mysql database to save the information only once? because if the player with the id 50 play the first level, will add a line with the information, but if the same player play the first level again and change the amount of stars, I dont want a new line, just update the stars amount.</p>

<p>I take a look in the INDEX, UNIQUE, PRIMARY, FULLTEXT, SPATIAL functions but dont figured out what is the correct combination and how to put in the php script, and take a look in other questions in the forum but nothing like this.</p>

<p>thanks for the help! </p>