[Sputnik53]

Hi, I've got SQLx to connect to db succesfully. Then I got confused about reading stuff to arrays, so I'm asking what would be a way to read SQL data to an array?

In php I used mysql_fetch_row($sql); so is there a corresponding function in SQLx?

[danielkza]

The SQLx approach is different, you have to read it row in separate with SQL_ReadResult. If you really need to read it to arrays, you can use the functions from cellarray.inc to achieve it.

Ask if you need an example.

[Sputnik53]

I'd love an example, no idea how am I gonna do this without one. :/

[danielkza]

What exactly do you want to do? Just read data from an simple query? Do you need to store it for later use?

[Sputnik53]

I want to read 1 row from the table.

SELECT * FROM table

and get all the values into the array.

[danielkza]

Originally Posted by Sputnik53 I want to read 1 row from the table. SELECT * FROM table and get all the values into the array.

As I said, this is not the normal approach in AMXX. Tell me if you need the data for imediate use or for long-term storage.

[Sputnik53]

Immediate use.

[danielkza]

Originally Posted by Sputnik53 Immediate use.

I'll post a working example in a few minutes.

[Sputnik53]

Originally Posted by danielkza I'll post a working example in a few minutes.

Great thanks alot. +karma'd

[|PJ| Shorty]

a function like in php is not accessable.
you have to save the results manually like:

 
new g_var[10][36]
...
SQL_ReadResult(Query,0,g_var[0],35);
SQL_ReadResult(Query,1,g_var[1],35);
SQL_ReadResult(Query,2,g_var[2],35);
 
... and so on

example for strings...