Re: [PHP] Re: storing array in mysql

2001-08-01 Thread elias
or data > (65k runs out fast), and that is a bit slower as well. > > Warren > > -Original Message- > From: elias [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 31, 2001 8:09 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] Re: storing array in mysql > > Yes true, you

RE: [PHP] Re: storing array in mysql

2001-07-31 Thread Warren Vail
: Tuesday, July 31, 2001 8:09 AM To: [EMAIL PROTECTED] Subject:Re: [PHP] Re: storing array in mysql Yes true, you can use serialize. But since you know the format of your $array variable (which is simply holding one data type) you can safely use split() and join() better and smaller when

Re: [PHP] Re: storing array in mysql

2001-07-31 Thread elias
Yes true, you can use serialize. But since you know the format of your $array variable (which is simply holding one data type) you can safely use split() and join() better and smaller when stored in that field because they are comma seperated. "Warren Vail" <[EMAIL PROTECTED]> wrote in message 0

RE: [PHP] Re: storing array in mysql

2001-07-31 Thread Warren Vail
What I have used to store an array in mysql is; $value = addslashes(serialize($array)); $query = "INSERT INTO table (column) VALUES (\"$value\")" and upon retrieval $query = "SELECT column FROM table"; .. while($row = mysql_fetch_array($result)) { $value = unserialize(stripslashes($r