Re: Separating value fields from one column to multiple column

On Monday 28 April 2003 16:11, John W. Holmes wrote: > So why are you asking on a PHP list? Find an oracle list/help board and > ask there. Thanks for ur help, and sorry for my silliness. Can you mention that oracle list/help board ? Thanks once again for ur Help Best Regards, Hendri > ---John W. Holmes... > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > today. http://www.phparch.com/ > > > -----Original Message----- > > From: Hendri [mailto:c4c3m@myrealbox.com] > > Sent: Monday, April 28, 2003 3:01 AM > > To: holmes072000@charter.net > > Cc: php-db@lists.php.net > > Subject: Re: RE: [PHP-DB] Separating value fields from one column to > > multiple column > > > > i mean in oracle, because its to much data in that table > > > > -----Original Message----- > > From: "John W. Holmes" <holmes072000@charter.net> > > To: "'Hendri'" <c4c3m@myrealbox.com>, > > "'php'" <php-db@lists.php.net> > > Date: Mon, 28 Apr 2003 02:09:59 -0400 > > Subject: RE: [PHP-DB] Separating value fields from one column to > > multiple > > > column > > > > > I have a big trouble maintaining fields in Oracle, My Case is : > > > in one field 's_misc' it contains value with "()" separation: > > > (Name)(Address)(Proffesion) > > > > > > Then i want to separate this value to another column to > > > > > > s_name > > > s_address > > > s_proffesion > > > > $elements = explode(')(',substr($s_misc,1,-1)); > > > > That'll give you each of the values inside of the parenthesis in an > > array. This is after you pull the value out of oracle, btw. > > > > ---John W. Holmes... > > > > PHP Architect - A monthly magazine for PHP Professionals. Get your > > copy > > > today. http://www.phparch.com/ > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php -- Hendri 'cacem' Hobbys Programmer MCP (Microsoft Certified Pirate)