sqllite easy question

[aintaro]

Hello guys,

How do I retrieve certain information from a certain column in a table with sql?

thanks in advance,

greetz Aintaro

[Markeloff]

  
local connection = nil 
function query( ... ) 
    if connection then 
        local qh = dbQuery( connection, ... ) 
        local result = dbPoll( qh, -1 ) 
        return result 
    else 
        return false 
    end      
end 
  
function querySingle( str, ... ) 
    if connection then 
        local result = query( str, ... ) 
        if type(result) == 'table' then 
            return result[1] 
        end 
        return result 
    else 
        return false 
    end 
end 

I hope it helps.