after a game is finish…it generate result…after calculating…some number…result can be…a number…Example…2 or 3 or 5…So…I want to upload that result from user app…in mysql data base…and show in user app…( result can be Number 2 or 3 )
If i upload result from user app…to mysql data base…
i found a problem… …
and problem is…if 4 user use that app…
4 result is upload in mysql data base…
but i wan if 1000 user’s use that app…then also…single result sud be upload from user app
Can you please improve the explanation?
Upload result?
Well, I still don’t understand … but …
…
…
…
If you want the result for each user, create a Key for each user. And create a record (row) with the Key (id) and that score.
If you need to change user points 567 do the UPDATE set score = value where Key = 567.
actually when a user use my app… it auto generate… result…Eg: 2 or 4
and show that result in ( result history screen)
itz simple n working fine…
But if 3 user use the app…then the app upload 3 result…
But i want single result should be upload for every user
Did you read ?
And how do you define what the result should be?
user1 10:10 am
user2 10:01 am
user3 11:23 am
What should be the result to be shown?
How is the routine that defines this result 2,3,4 ???
every 5 min…the result show to every user…result can be random…from…0 to 10…
and it got save to mysql data base…
and show in list…
as it is in list… if 10 user use…the app… i got 10 list of result…
But i want singal result for all user
Confused …
Friend, if you want to show only 1 result, then don’t do the INSERT command. Insert Into creates rows (records in the database).
If you want only 1 result to appear, UPDATE this record.
Update will update the registry.
If the field had a value of 3, and the new update value is 9, then when UPDATE the value will be shown will be 9.
ok i will try this
before update app will have to create so all user app will create a record.