title: return array in lua from a sqlite database
body: <p>How do you return an array from a sqlite database in lua?</p>
  
  <p>I have this sameple code here:</p>
  
  <pre><code>function getMoveName()
      tempMoveName = {}
      for row in db:nrows("SELECT * FROM movetable") do
          tempMoveName = row.movename .. " " .. row.totalcubicfeet .. " " .. row.totalitem .. "\n"
      end
      return tempMoveName
  end
  </code></pre>
  
  <p>which will return the content of the database and then print the content with this line of code:</p>
  
  <pre><code>local displaymovenames = mydatabase.getMoveName()
  
  print ( displaymovenames )
  </code></pre>
  
  <p>however it only returns the last data and not all of the contents of it.</p>