Storing arrays

Discussions around the use of MySQL on VMS
Post Reply
Message
Author
User avatar
beaudoin_p
$ HELP
Posts: 13
Joined: Fri Oct 21, 2005 10:31 am
Location: London UK

Storing arrays

#1 Post by beaudoin_p »

Gents,

I have an application that needs to store arrays in MYSQL and process them in PHP. The elements are either floating point numbers or timestamps. There may be up to 2000 elements and hundreds of arrays. THe only scheme I can think of now is to convert each array to a comma seperated string, store it as a blob and upon retireval, EXPLODE it and convert it back for processing. Surely there is a better way? I will keep track of the indexes and such in the code.

Many thanks

Paul

Post Reply