MatXpl Posted December 5, 2013 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 MTA:SA scripts/gamemodes/misc: http://www.mtasa.xn.pl
Martyz Posted December 5, 2013 Posted December 5, 2013 Do you want to update data in mysql or insert new row?
MatXpl Posted December 5, 2013 Author Posted December 5, 2013 update MTA:SA scripts/gamemodes/misc: http://www.mtasa.xn.pl
Martyz Posted December 5, 2013 Posted December 5, 2013 Then you should use UPDATE: mysql_query(handler, "UPDATE accounts SET x=" .. x .. ", y=" .. y .. ", z=" .. z .. " WHERE login='" .. accName .. "'")
MatXpl Posted December 5, 2013 Author Posted December 5, 2013 still dosn't work MTA:SA scripts/gamemodes/misc: http://www.mtasa.xn.pl
MatXpl Posted December 5, 2013 Author Posted December 5, 2013 nope. everything should working. i used in another script SELECT * and INSERT and it's working. MTA:SA scripts/gamemodes/misc: http://www.mtasa.xn.pl
MatXpl Posted December 5, 2013 Author Posted December 5, 2013 i don't know why, but now it's working thanks! MTA:SA scripts/gamemodes/misc: http://www.mtasa.xn.pl
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