[RESOLVED] MySQL field as array?

Salvis

Hello,
I have mysql table with field with contains something like array.
Field structure is like this - name=position,name=position,name=position,...
Like:

Jim Chi=Director,Melly Kate Brown=Producer,Kathy Singer=Actor,...

I need to print this info in page like:

Name: Jim Chi Position: Director
Name: Melly Kate Brown Position: Producer
Name: Kathy Singer Position: Actor
....

How it can be done?
Any script samples?
Thanks!

djjjozsi

create a table:

data:
id , name, position

And store these values in separate rows.

CREATE TABLE  `data` (`id` int(11) NOT NULL auto_increment,
PRIMARY KEY  (`id`),
  `name` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL
         ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

halojoy

I am sure there are other ways,
but I have written a small code that will work.

Output:

Name: Jim Chi, Position: Director
Name: Melly Kate Brown, Position: Producer
Name: Kathy Singer, Position: Actor

<?php

$input = "Jim Chi=Director,Melly Kate Brown=Producer,Kathy Singer=Actor,";

$string = rtrim($input, ','); // remove eventual comma at the end
$arr = explode(',', $string); // split the string at each comma
foreach($arr AS $x){
    $item = explode('=', $x); // split each at '='
    echo 'Name: '.$item[0].', Position: '.$item[1].'<br />';
}

?>

halojoy

djjjozsi;10938924 wrote:
create a table:

data:
id , name, position

And store these values in separate rows.

I agree absolutely.
This would be the very best thing to do.

Salvis

Thanks for sugesstions.
halojoy, your code was that i looking for. Thanks!