[pride95]

PHP Code:

    the_servers = CreateArray(ByteCountToCells(50));

        Handle array_row = CreateArray(3);

        while(SQL_FetchRow(hndl)) {
            ClearArray(array_row);
            SQL_FetchString(hndl, 0, name, sizeof(name));
            PushArrayString(array_row, name);
            SQL_FetchString(hndl, 1, serverip, sizeof(serverip));
            PushArrayString(array_row, serverip);
            PushArrayCell(array_row, SQL_FetchInt(hndl, 2));
            PushArrayCell(array_row, SQL_FetchInt(hndl, 3));
            PushArrayArray(the_servers, array_row, 3);
        } 


error on line with PushArrayArray. argument type mismatch (argument 2). what im doing wrong?

[Dr!fter]

You are pushing an ArrayList which is a handle to data. If you want to push that you use PushArrayCell. PushArrayArray is for int arry[3]; for example.

[WildCard65]

Also, your creating the ArrayLists wrong

the blocksize parameter is the number of cell blocks per index (for arrays)

PHP Code:

the_servers = CreateArray(); // 1 block per index should be enough for Handles
... 


PHP Code:

...
Handle array_row = CreateArray(ByteCountToCells(50)); // 13 blocks should be plenty of space for strings
... 


Also, you do not need to call ClearArray on freshly created arrays.