[LUA]Mysql_Query() not counting rows

[Lorthir 0]

Hello!

 

I'm trying to count the number of entries that I've in this table, but my function isnt working!

local kills = mysql_query("SELECT COUNT(*) FROM database.table")

Can anybody fix this?

[Alina 275]

The query is correct. Can you show us what you're doing with "kills" after the query executed? Also make sure your quest can use mysql queries via mysql_query() function

[Lorthir 0]

yes

 

The query is correct. Can you show us what you're doing with "kills" after the query executed? Also make sure your quest can use mysql queries via mysql_query() function

 

I'm trying after that to make and if statment comparing a number and the return of the query! example:

if kills >= 3 then
 syschat("hi")
end

[Izaya 15]

Well of course this won't work because mysql_query returns table (if you are using mijago's function). You propably wan't to do it like this:

local kills = mysql_query("SELECT COUNT(*) FROM database.table")[1][1]

[Lufbert 21]

And query didn't return a number but string. You must edit if kills ... To if tonumber(kills) ...

[layfon 4]

Hello!

 

I'm trying to count the number of entries that I've in this table, but my function isnt working!

local kills = mysql_query("SELECT COUNT(*) FROM database.table")

Can anybody fix this?

 

local kills = mysql_query("SELECT COUNT(*) FROM database.table")

local row = table.getn(kills)

say("Kill : "..row)

 

 

try this