RE: [PHP-DB] store an array in a mysqldb

2001-08-31 Thread Peter J. Krawetzky
If you are setting up a true relational database, arrays would be stored in a seperate table with a unique key. Each part of the array would be a seperate row. This is called normalization. If you are doing it for fun, then you could place some type of seperator (like a comma, semicolon, etc) b

Re: [PHP-DB] store an array in a mysqldb

2001-08-30 Thread Justin Buist
Nothing comes to mind that isn't a bit of a "hack" really. You could try seperating the data with delimiters before putting it in, then splitting the data back up into an array at query time. You could setup some tables, one called 'arrays' and one called 'array_values". Arrays would pretty muc