I have a UI where a user can select a value and it will save it and their steam ID (as the primary key) into the database. On a button click (in a derma panel) after selecting their value, the client writes a net string and sends it to the server. The net string contains the value we want to save to the database. The server receives the message and I print out all the values and variables to make sure everything is correct. It is, but for some reason the DB row doesn't update when I query. I print out the exact query its sending and display it in the console. When copying and pasting the displayed query into the Sqlite DB browser it executes and the row is updated, but for some reason it doesn't when I send the query through gmod.
Msg("UPDATE table SET column2='".. var_upating .."' WHERE column1='"..ply:SteamID().."'")
Any help is appreciated, thank you!
itd be nicer if you didnt delete your subject because some other people may encounter a similar problem too and they would get help from how you fixed it
Sorry, you need to Log In to post a reply to this thread.