Jump to content

[HELP] Update a specific mysql colum with dbExec


..:D&G:..

Recommended Posts

Posted

Hello, I am trying to make a login system, and I want a function to update a specific username's data value.

dbExec( connection, "UPDATE `??` SET `??`=?", tableName, columnName, columnValue ) 

The problem with this is that I don't know how to make it so it updates the column only for a specific username, like "UPDATE 'accounts' WHERE 'username'="..user.." "

Thank you.

76561198066470453.png

SP37Ecj.jpg?2MTA:Rust Pre-Alpha Build v.0.3:SP37Ecj.jpg?2

https://forum.mtasa.com/viewtopic.php?f=114&t=97848

2Pac: ''Only God can judge me!''

Posted
dbExec( connection, "UPDATE `??` SET `??`=? WHERE username = ?", tableName, columnName, columnValue, username ) 

San Andreas Utopia RPG (SAUR) Owner & Developer.

560x95_FFFFFF_FF9900_000000_000000.png

Education is the most powerful weapon which you can use to change the world.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...