How can I select a string from mysql?

[Dimmi 19]

Hi guys.

How can I make a function to select a string (varchar in database) in a quest.

For example, to select "test" (which is an integer) from table "test", I use a function like this:

function get_test ()
	local r = mysql.query("SELECT test FROM player.test LIMIT 1")
	return r[1][1]
end

How can I make a function to select a string?

Please help!

[Benhero 23]

maybe return tostring(r[1][1]) ?

 

or...

function get_test(text)
    local r = mysql_query("SELECT " ..text.. " FROM player.test LIMIT 1")
    return tostring(r[1][1])
end

[Dimmi 19]

It returns

nil

but thanks for advice, anyway...

[Cataclismo 86]

It returns

nil

but thanks for advice, anyway...

 

That's strange. It should actually work exactly how selecting integer works.

Try using extended MySQL query: 

SELECT `column` FROM player.table LIMIT 1;

Also, do you use source? It would be easier to use the source.

[Dimmi 19]

It returns

nil

but thanks for advice, anyway...

That's strange. It should actually work exactly how selecting integer works.

Try using extended MySQL query:

SELECT `column` FROM player.table LIMIT 1;

Also, do you use source? It would be easier to use the source.

Yes, I'm using source. Function I used (mysql.query) was added by source, but the query it's ok, cuz' always I test my query in Navicat. The problem is in variable (I think), because integer variable works.

[V0iĐ 111]

Could you show your mysql query function?