Hi i have a table Users which have a field "score" to store the current score of the game. Now lets say the user have played a level and has obtain a highest score. So it should update it in the DB. How will i do this comparison? the highest score is store in the variable current score. i need to compare if currentscore>score(in the table) -> then update the field. Anyone can help? it should be in php code

Edited by techyworld

5 Years
Discussion Span
Last Post by pixelsoul

How would you like us to help you? We can give directions on how to solve the problem but we won't give the code. Do you have any code to show us?


I have a field dbscore in my database and it it an array of 5(5 level). lets say i have a new score for level 3. I want to update that score in the database for that particular level. the code below is updating the values but i think it's not correct since the dbscore is an array. Can someone help?

$score is my new score.

mysql_query("UPDATE score SET dbscore='$score' WHERE name='$name'");
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.