Jump to content

[HELP] MySQL column


-Note

Recommended Posts


Hello can anyone help me here

I want to make this work for the staff that are in "username"and permission is "true" in my MySQL Column 

For example:

Column Name staffUser:

  • value (iNote)

Column Name hasPermission:

  • value (true) 

Srry forgot to paste my code!

 

function voidFunction(plr)
local query = exports.mysql:query("SELECT * FROM staff")
    for k,v in ipairs (query) do
		memberName = v.staff_name
		outputChatBox(memberName..", please don't misuse this power!", plr, 255, 255, 255)
	end
end
addCommandHandler("void", voidFunction)

 

Srry forgot to paste my code!

 

function voidFunction(plr)
local query = exports.mysql:query("SELECT * FROM staff")
    for k,v in ipairs (query) do
		memberName = v.staff_name
		outputChatBox(memberName..", please don't misuse this power!", plr, 255, 255, 255)
	end
end
addCommandHandler("void", voidFunction)

 

Link to comment

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...