[PHP] MySQL and PHP arrays

2003-03-10 Thread {R}ichard Ashton
Is there a generally recommended way of storing an array created by PHP in a MySQL database field ? What type of field should it be, and how do you get the whole array back in one go without reconstructing it row by row, if that is possible? {R} -- PHP General Mailing List

Re: [PHP] MySQL and PHP arrays

2003-03-10 Thread Jason Wong
On Monday 10 March 2003 22:30, {R}ichard Ashton wrote: Is there a generally recommended way of storing an array created by PHP in a MySQL database field ? serialize() and unserialize(). What type of field should it be, and how do you get the whole array back in one go without reconstructing

RE: [PHP] MySQL and PHP arrays

2003-03-10 Thread Messay W Asfaw
Serializing it would be the best way: seralize($myArray) then you can get the array back using unseralize($serializedarray) -Original Message- From: {R}ichard Ashton [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 14:31 To: [EMAIL PROTECTED] Subject: [PHP] MySQL and PHP arrays

Re: [PHP] MySQL and PHP arrays

2003-03-10 Thread {R}ichard Ashton
On Mon, 10 Mar 2003 22:34:44 +0800, Jason Wong wrote: On Monday 10 March 2003 22:30, {R}ichard Ashton wrote: Is there a generally recommended way of storing an array created by PHP in a MySQL database field ? serialize() and unserialize(). What type of field should it be, and how do you get

Re: [PHP] MySQL and PHP arrays

2003-03-10 Thread Mike Mannakee
You get at the data through $array = mysql_result($result,0,0); Mike {R}Ichard Ashton [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Mon, 10 Mar 2003 22:34:44 +0800, Jason Wong wrote: On Monday 10 March 2003 22:30, {R}ichard Ashton wrote: Is there a generally recommended way

RE: [PHP] MySQL and PHP arrays

2003-03-10 Thread Van Andel, Robbert
:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:45 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] MySQL and PHP arrays You get at the data through $array = mysql_result($result,0,0); Mike {R}Ichard Ashton [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Mon, 10 Mar 2003 22:34:44