… when i play in my game then after playing the score are submitting to database then when i go to main menu then i checked the score… its not automatic update,
it needs to relaunch the project b4 the score is updated…
i use this code:
function scene:createScene( event )
local group = self.view
local count = 0
local viewGroup = display.newGroup()
for row in db:nrows("SELECT * FROM test ORDER BY score desc LIMIT 15 ") do
local t = display.newText(row.content, 20, 30 * row.id, null, 16)
t:setTextColor(255,0,255)
count = count +1
local txts = row.score…" "…row.content2
local viewdata = display.newText(viewGroup,txts, 100, 65 + (20 * count), native.systemFont, 20)
viewdata:setTextColor(255,0,255)
end
group:insert( viewGroup)
end