Selecting a thing from SQL

[Chamberlien]

okay so I was wondering how to select something like from the data base 'rpserver' and the table 'settings' and it has a MOTD line how would I be able to show that using paradise MySQL so like it shows on a outputChatBox?

[Castillo]

local result = exports.sql:query_assoc_single ( "SELECT * FROM settings WHERE name = 'motd'" ) 
if ( result ) then 
    outputChatBox ( tostring ( result.value ) ) 
end 

Database cannot be specified when using MTA Paradise game mode, you have just one database set on "sql/mysql.lua".

[Chamberlien]

Yea I know I'm not working on MTA Paradise I'm improving on Venux

btw Thanks

[Castillo]

You're welcome.

P.S: "value" is the column name.

[Callum]

local result = exports.sql:query_assoc_single ( "SELECT * FROM settings WHERE name = 'motd'" ) 
if ( result ) then 
    outputChatBox ( tostring ( result.value ) ) 
end 

Database cannot be specified when using MTA Paradise game mode, you have just one database set on "sql/mysql.lua".

Selecting * can be a potential performance deficiency. You should only select the columns you need, using the format;

"SELECT column1, column2, column3 FROM table WHERE column4 = 'value' LIMIT 1" 

PS: Using 'limit 1' makes the server stop the query after fetching 1 result. This is very good for increasing performance (so if the result is row 500 or 100000, it doesn't loop the other 99500 rows).

[Chamberlien]

I'm just using three simple MySQL tables also I have advanced on this code structure thanks again( no one else repply )