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 much be one column -- just the id. Array_values would
be 4 columns (3 if order doesn't matter) with: array_value_id, array_id,
value, sequence (optional).
However, I should probably note last I knew PostgreSQL supports the
insertion of arrays into a record natively... though I have never
personally used it.
Justin Buist
Trident Technology, Inc.
4700 60th St. SW, Suite 102
Grand Rapids, MI 49512
Ph. 616.554.2700
Fx. 616.554.3331
Mo. 616.291.2612
On Thu, 30 Aug 2001, Jeroen van Bussel wrote:
> I would like to know if it is somehow possible to store an array in a mysql
> DB.
>
> Could somebody please help me.
>
> greetz Jeroen
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
