MatXpl Posted December 5, 2013 Share Posted December 5, 2013 (edited) 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 Link to comment
Martyz Posted December 5, 2013 Share Posted December 5, 2013 Do you want to update data in mysql or insert new row? Link to comment
Martyz Posted December 5, 2013 Share Posted December 5, 2013 Then you should use UPDATE: mysql_query(handler, "UPDATE accounts SET x=" .. x .. ", y=" .. y .. ", z=" .. z .. " WHERE login='" .. accName .. "'") Link to comment
MatXpl Posted December 5, 2013 Author Share Posted December 5, 2013 still dosn't work Link to comment
MatXpl Posted December 5, 2013 Author Share Posted December 5, 2013 nope. everything should working. i used in another script SELECT * and INSERT and it's working. Link to comment
MatXpl Posted December 5, 2013 Author Share Posted December 5, 2013 i don't know why, but now it's working thanks! Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now