Hi. Well you need to install luasql, and work only with lua 5.0 or major.<br><br>You need a ODBC connection to MySQL.<br><br>And there is an lua script example:<br>============================================================<br>
#!/usr/local/bin/lua<br>require "luasql.mysql"<br><br>env = assert (luasql.mysql())<br>con = assert (env:connect("DB","user","password","localhost))<br>cur = assert (con:execute"SELECT id, name FROM test")<br>
row = cur:fetch ({}, "a") <br>while row do<br> print(string.format("Id: %s, Name: %s", <a href="http://row.id">row.id</a>, <a href="http://row.name">row.name</a>))<br> -- reusing the table of results<br>
row = cur:fetch (row, "a")<br>end <br><br><br><br>cur:close()<br>con:close()<br>env:close() <br>==========================================================<br><br>regards<br>javar<br>