How to get more than one result

[FWCentral]

Ok im trying to create a spawn system using SQLite.

Creating the table

  
executeSQLCreateTable ( "Spawn", "name TEXT, gang TEXT, city TEXT, type TEXT, x REAL, y REAL, z REAL, wep1 INTEGER, wep2 INTEGER, wep3 INTEGER, wep4 INTEGER, wep5 INTEGER, wep6 INTEGER, skin1 INTEGER, skin2 INTEGER, skin3 INTEGER") 

Now is this how i would get all the results from each field of the table?

GetSpawns = executeSQLSelect ( "Spawn", "*") 

[Edikosh998]

  
  
executeSQLQuery("SELECT * FROM Spawn") 
  
  
  

[FWCentral]

Thanks man, How will this return the results?

[Jaysds1]

Thanks man, How will this return the results?

it returns the a table full with the results:

https://wiki.multitheftauto.com/wiki/ExecuteSQLQuery

[FWCentral]

Thanks i managed to create the table and insert data into the table but i want to now retrieve the data from the db and I've used executeSQLQuery to get the table now how can i use that table and the things in it i don't understand

[Jaysds1]

like this:

{ 
    { colname1=value1, colname2=value2, ... }, 
    { colname1=value3, colname2=value4, ... }, 
    ... 
} 

[FWCentral]

Yeah i know it returns like that and that's what i don't understand, I retrieve the table from the DB, Then how can i use the data? Let's say i want to output all the data through the chat box how would i do it?

[Jaysds1]

here's a preview:

table = executeSQLQuery("SELECT * FROM Spawn") 
--[[ table = { 
    { colname1=value1, colname2=value2, ... }, 
    { colname1=value3, colname2=value4, ... }, 
    ... 
    } 
]] 
  
|name|gang|city|type|x|y|z|wep1|wep2|wep3|wep4|wep5|wep6|skin1|skin2|skin3| 
|   |   |   |   |   |   |   |   |   |   |   |   |   |   |   |   |   |   |   | 
|   |   |   |   |   |   |   |   |   |   |   |   |   |   |   |   |   |   |   | 

[FWCentral]

Thanks man that helped me a lot

[Jaysds1]

np