Saving an Array of Objects to MYSQL Database, and Retrieving It

[DrRobot]

How do i save an array of objects, like this: [{n:1,bb:4},{n:2,bb:4,r:1},{n:6,bb:7},...] to a database? I was thinking i would have to convert it to string, but if i do that, when i retrieve it from the database, how am i going to use it?

EDIT: forgot to mention that the objects can contain an array of objects as well, but there won't be any more arrays beyond that point.

[{n:1,bb:4},{n:2,bb:4,r:1},{n:6,bb:7},{arr:[{a:11,b:2},{a:11,b:2},...],r:1},...]

[Eric Drutel]

You could save each object from the array as a different record in a table from database. If is necessary to load the whole array you could create a table array_items with following column structure: id, array_id, n, bb, r... When loading select all records that have the required array_id and rebuild your array.

Just a taught, maybe it would be better to use some server side code for the business logic and the interaction with the database.

[DrRobot]

good idea, but i forgot to mention that the there could be an array in the object.

[{n:1,bb:4},{n:2,bb:4,r:1},{n:6,bb:7},{arr:[{a:11,b:2},{a:11,b:2},...],r:1},...]