Re: [PHP-DB] array field type

2007-03-06 Thread Tony Marston
Sancar Saran [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Sunday 04 March 2007 23:04, Sancar Saran wrote: Hi, I want to know is there any db server around there for store php arrays natively. Regards Sancar Thanks for responses, it seems I have to give more info about

Re: [PHP-DB] array field type

2007-03-06 Thread Micah Stevens
Wrong! Take a look at the SET datatype http://dev.mysql.com/doc/refman/4.1/en/set.html. This allows you to have an array of values in a single field, and the user can select any number of them. Sort of, but not really: This is a really specialized keyword, and depends on binary mapping

Re: [PHP-DB] array field type

2007-03-06 Thread Mark
Sancar Saran wrote: Thanks for all those replies. It seems there was no easy solution (and or serializing was better solution) for us. Our arrays contains lots of things.. XML may not fit because content of array may broke xml structure. Before you give up, take a look at the XMLDBX PHP

Re: [PHP-DB] array field type

2007-03-05 Thread Bastien Koert
-db@lists.php.net, php-general@lists.php.net Subject: Re: [PHP-DB] array field type Date: Sun, 04 Mar 2007 15:04:42 -0800 Not a single field, but there's several methods of storing trees of information, which is what an array is. Here's one: Nested Array storage table: ArrayID (int, autonumber

Re: [PHP-DB] array field type

2007-03-05 Thread Sancar Saran
Thanks for all those replies. It seems there was no easy solution (and or serializing was better solution) for us. Our arrays contains lots of things.. XML may not fit because content of array may broke xml structure. Thanks for help. Regards Sancar. Hi, I want to know is there any db

Re: [PHP-DB] array field type

2007-03-04 Thread Sancar Saran
On Sunday 04 March 2007 23:04, Sancar Saran wrote: Hi, I want to know is there any db server around there for store php arrays natively. Regards Sancar Thanks for responses, it seems I have to give more info about situation. In my current project, we had tons of arrays. They are very deep

Re: [PHP-DB] array field type

2007-03-04 Thread Micah Stevens
Not a single field, but there's several methods of storing trees of information, which is what an array is. Here's one: Nested Array storage table: ArrayID (int, autonumber) keyname (text) parent (int) data (bigtext or whatever would be appropriate for the data you're storing) For an array