full sql info

[Snow-Man]

how to get all data from sql, in my script it's show me only recent data

function getTransactionBankLog(player)
	if (player) then
		local transaction = exports.USCsql:query( "SELECT * FROM bank_transaction WHERE accName = ?", getAccountName(getPlayerAccount(player)))
		if transaction and transaction['log'] and transaction['date'] then
			local tran, date = transaction['log'] ,transaction['date']
		return tran, date
      	else
      	return false
		end
	end
end

 

[Citizen]

Assuming exports.USCsql:query can return an array of rows when appropriate, this should work:

function getTransactionBankLog(player)
	local transactions = {} -- create a list
	if player then
		local results = exports.USCsql:query( "SELECT * FROM bank_transaction WHERE accName = ?", getAccountName(getPlayerAccount(player)))
		if results then
			for transaction, i in ipairs(transactions) do -- loop the results
				if transaction and transaction['log'] and transaction['date'] then
					table.insert(transactions, {tran = transaction['log'], date = transaction['date']}) -- filling the list from each result
				end
			end
		end
	end
	return transactions -- return the list
end

You should be able to use it like this:
 

local transactions = getTransactionBankLog(somePlayerElement)
for transaction, i in ipairs(transactions) do
	outputChatBox("#"..i.." -> tran: "..tostring(transaction.tran)..", date: "..tostring(transaction.date))
end

 

[Snow-Man]

i have tried your code and i got result  -> table:2482C1F8

my code is works good but i only get one data

[Snow-Man]

help?