NEED help about showing results or smt

[tigerman]

function testing(thePlayer, command) 
    local players = executeSQLQuery("SELECT milk FROM database") 
    outputConsole("test:", thePlayer) 
    for i, data in ipairs(players) do 
    bauh = data.milk 
        outputConsole("Blabla : " ..bauh, thePlayer) 
    end 
end 
  
addCommandHandler("te", testing) 

executeSQLCreateTable("database", "milk INT")

Ok, this should show all values that are in "milk" database, but it dont do anything, even no errors..

[dzek (varez)]

did you store anything?

just creating database and reading values will return nothing, as nothing is stored in DB

[tigerman]

Yes, it stores wins for players

[Aibo]

milk stores wins?

[tigerman]

yes

[Aibo]

are you sure? :3

get some SQLite database manager (http://code.google.com/p/sqlite-manager/ for example) and check if there is anything in your database.

because it looks like you've edited a wiki example from executeSQLQuery page. and no mentions here that anything was stored in your milk database.

PS: better not call your table "database". it can be confusing and no way to tell to which resource it belongs.

[tigerman]

16 results in this database, so yes im sure

[dzek (varez)]

if you are sure it contains data then..

you are outputting it to console - are you checking the console or chatbox? it will be shown only in client console, not server.

script looks fine, so if there is a data - it will output to console. if there is no data - there will be no output

[tigerman]

Im testing it on local server (windowed mode) so im checking both and still nothing

[Aibo]

"console" here means player console (~ or F8 key ingame), not server console.

[tigerman]

Hah, works fine in F8 ^^ thanks u both

[Aibo]

facepalm.jpg

[tigerman]

Now if i only would find out way how to sort/list them by growing like 9 8 4 3 1 etc.. then my life would be perfect

[Aibo]

executeSQLQuery("SELECT milk FROM database ORDER BY milk DESC")

[dzek (varez)]

i need to do the same: