Hello Everybody,
I have a dynamic multi-dimensional array, I am using sendAndLoad to store the information in MySQL. I can get it to send and store. The problem is the format that it is storing is like a plain array like such

0, MovieClip_0, 2, blahblah, Edge, 2, Some Text, Some More Text, Even More Text

I need to be able to retrieve the data and restore it back in the multi-dimensional format. The only way I can think to do this is to write the array out to a string and add some split characters like ~ or || then write some code to rebuild the array using the SPLIT function. This seems like a long and tedious way to do this. Does anybody else have any ideas or advice?

var RoomItems_arr:Array = new Array();

for(var l:Number=0; l < iItemCount; l++) {
    RoomItems_arr[l] = new Array();

    RoomItems_arr[l][0] = l;
    RoomItems_arr[l][1] = "MovieClip_"+l;
    RoomItems_arr[l][2] = 2;

    RoomItems_arr[l][3] = new Array();
    for(var i:Number=0; i <= iSideCount; i++) {
        RoomItems_arr[l][3][i] = new Array();
        RoomItems_arr[l][3][i][0] = "blahblah;
        RoomItems_arr[l][3][i][1] = "Edge";
        RoomItems_arr[l][3][i][2] = 2;
    }

    RoomItems_arr[l][4] = "Some Text";
    RoomItems_arr[l][5] = "Some More Text";
    RoomItems_arr[l][6] = "Even More Text";

}

Thanks In Advance
mike

__________________
Peace
Mike
http://www.eclecticpixel.com

I am not sure I follow your request. Do you want to retrieve multiple fields and put them in an array to display with flash? Then possibly allow the user to change the data and send the data back?

If so check out this project. It uses arrays, data grids, insert/update/delete sql functionality with mysql and php.

http://flash-creations.com/notes/ser...m_database.php

it does all the basics.