Sign in to follow this  
Followers 0
dekela

Save database query as an array

1 post in this topic

 i have a database table called "price". columns are "econItem", "econMin", "econPrice", "econMax"

i want to retrieve all the values from the "econItem" column based off price,  and save them as an array. 

Am I on the right track? 

exile.ini

[getEconItem]
SQL1_1 = SELECT econItem FROM price WHERE econPrice = ?
Number of Inputs = 1
SQL1_INPUTS = 1
OUTPUT = 1

 

Call from sqf

_data = format [ "getEconItem:%1", 550] call exile_server_system_database_query_selectSingle;

Will the data from this call already be in an array or some other format? 

Thanks

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Support Exile (2018)

    If you would like to help us keeping the Exile community and the XM8 app online, please consider donating. Thank you! <3


    110.00 EUR of 100.00 EUR goal reached.
    Donate Now
  • Live Development
    10k followers possible?
  • Advertisement