how to Select the Max value of my Database?

Other
#1

Hi all

Please i’m trying make a database for get the max value of points of my game.

But i do not know how do it.

Anybody help me please?

This is my code:

function Show() for row db:nrows("SELECT MAX(coins)AS coin FROM GAMEPOINT")do print(row.coins) end Runtime:removeEventListener("enterFrame",Show) end
#2

should you not be printing row.coin instead of row.coins?

#3

should you not be printing row.coin instead of row.coins?