local dbConf = {}
dbConf.database = 'mitglieder'
dbConf.username = 'fritz'
dbConf.passwort = 'geheim'
dbConf.hostname = '10.234.123.45'
dbConf.port = "3306"

require("mime")
luasql = require("luasql.mysql")

local env = assert(luasql.mysql())
local con = assert(env:connect ( dbConf.database, dbConf.username, dbConf.passwort, dbConf.hostname, dbConf.port ))


function rows (connection, sql_statement)
  local cursor = assert (connection:execute (sql_statement))
  return function ()
    return cursor:fetch()
  end 
end


for id, name, address in rows (con, "select * from dealer_logins") do
        -- "id" und "name" sind Spaltennamen in der Tabelle
        print (string.format ("%s: %s", id, name))
end


con:close()
env:close()