Calamity

ok got it working, appreciated.

so how would i say

local totalX=mysql_query("SELECT points, FROM account.account WHERE id = ".. pc.get_account_id() ..";")
chat(totalX)

did test this but i cant see the syntax error :/

when i entered it directly into putty, i got the correct output as one would expect

modified the post above with the output

output from using the exact quest provided 

Hi, I'm working on something and for it to work in the manner that i require it. I need it to return a value from the database. It always returns a value of 0.

here's the function

function total_points(x)
local z = os.execute("mysql -u root account --execute='SELECT `points` FROM account.account WHERE id = ".. pc.get_account_id() ..";'")
return z
end

I've tested the query in navicat and it works fine, i can insert ints into the database but not strings??? 

i've tried using a mysql_query function but it wouldnt return any value. if someone has a working mysql_query function simlair to this, i'd appreciate if you could post it here as i could have used the wrong syntax for that.

any help is appreciated. 

I can't find any information on this so the first person to solve it gets 15 euros via Paypal, but i must be able to select any information and insert any rather than just inserting int's .

information - i'm on 34k

server files -  im using are macross's