SQL Output rows?

I would like to know, when you have a database table with a couple of rows, how to firstly print a count of how many rows there are and secondly how to output/print a specific column of each row, with some sort of loop.

The SQL Tutorial on the Wiki and on facepunch just SELECT something and then look if there is a result, but they never show you how to get the values.


You can count them by doing: sql.Query(“SELECT Count(*) FROM table”);

the result of the query is either a boolean or table.
local count = sql.Query(“SELECT Count(*) FROM table”) will result a table which contains the count if the table exists, if it doesnt then it will return false.