mysql what's wrong ?

[MatXpl]

what is wrong here?

i got x,y,z arguments handler is working but stiil dont chanage data in mysql.

no debuging errors

local query = "INSERT INTO accounts SET x='" .. x .. "', y='"..y.."', z='"..z.."' WHERE login='"..accName.."'" 
mysql_query(handler, query) 

x,y,z in accounts is definied as 0

Edited December 5, 2013 by Guest

[Martyz]

Do you want to update data in mysql or insert new row?

[MatXpl]

update

[Martyz]

Then you should use UPDATE:

  
    mysql_query(handler, "UPDATE accounts SET x=" .. x .. ", y=" .. y .. ", z=" .. z .. " WHERE login='" .. accName .. "'") 
  

[MatXpl]

still dosn't work

[Martyz]

Any debugscript errors?

[MatXpl]

nope.

everything should working. i used in another script SELECT * and INSERT and it's working.

[MatXpl]

i don't know why, but now it's working thanks!

[Martyz]

No problem