What I'm trying to achieve is getting my Java application to successfully send the high score of a specific user to a database. I'm not sure how I would write the SQL code so it will see who the user is, and alter the high score column based on the username.
I have completed the registering process and checking to see if the user's credentials are valid.
Look for an mysql primer which explains the uses of the INSERT, UPDATE and DELETE stamements to you. For specific help, post the relevant table structures you're using.
Look for an mysql primer which explains the uses of the INSERT, UPDATE and DELETE stamements to you. For specific help, post the relevant table structures you're using.
Thank you very much, that's exactly what I needed! I just checked an example of the UPDATE query and I found my answer. I never thought about looking at the UPDATE function as I assumed I needed to use INSERT.