How to get the result of an query

[Michael Gohl]

Hey guys 

I am using the mysql-lua extension:

res, err, errcode, sqlstate =

                      db:query("select u, sfrom tableDB WHERE ik= '"..ik.."' and ip = '"..ngx.var.remote_addr.."'", 1)

But how can I get the answer?

res["u"], res.u, res[0]["u"] doesn't work. Can someone give me a hint?

Thanks

[Michael Gohl]

res[1] is it