MySQL problem

[pa3ck]

REMOVED

Edited December 9, 2013 by Guest

[Castillo]

Where is "connection" defined?

[pa3ck]

REMOVED

Edited December 9, 2013 by Guest

[TrapLord Studios™]

So it isn't connecting Bro?

[Castillo]

connection = dbConnect( "mysql", exports.global:getSQLData() ) 
  
-- getSQLData in global: 
  
function getSQLData() 
    return "dbname=mtasrv;host=127.0.0.1", "mtasrv", " -- ", "share=0" 
end 
  

And this code is on the same lua file as your other script?

[pa3ck]

REMOVED

Edited December 9, 2013 by Guest

[Castillo]

What does 'save' return? also, use dbExec for that sort of queries.

[pa3ck]

It returns true but what is the difference between dbQuery and dbExec?

[Castillo]

dbExec doesn't return anything.

[pa3ck]

I changed it to dbExec it works now, but what is the difference between dbExec and dbQuery? Will I need to use dbExec for updating / inserting / getting deatils to / from a table? Thanks a mill.

[Castillo]

dbQuery is used to obtain data, and dbExec is used for inserting, updating.

[pa3ck]

Ah, okay, thanks a mill! EDIT: Do I need to use dbFree after dbExec?

[Castillo]

No, dbFree is used with dbQuery.

[pa3ck]

Okay, got it sir, thank you! EDIT: One more question (facepalm) when do I need to use ``? Or I dont need to use it at all?

[Castillo]

It's used to escape MySQL reserved words.

[pa3ck]

Love you man, you helped me a lot, appreciated!

[Castillo]

You're welcome.