[RESOLVED] multi items in one cell in mysql.

[rbblue8]

Hey,

I'm basically looking for a way to store several thing in on cell and seperate each statment by a ; or a ,. So basically the cell would like this once it's pulled of of the mysql database.

data 1, data2, data 3, data 4 dfadsfsdf 6!

Now.. What i'm looking to do is have each string pulled from the able to become it's own value. something like this

$1=data1;
$2=data2;
$3=data3;

adding the information is (i think easy). It's pulling it out of the table and seperating each value is where i'm having an issue.

any ideas?

[esukf]

use explode()

[rbblue8]

hey,

thanks for that.

but i seperate them by using a , or a ; how do i tell explode that the seperator is the , or ; and not the space?

[esukf]

explode(",", $pizza);

//or from your data 1, data2, data 3, data 4 dfadsfsdf 6! example

explode(", ", $pizza);  //note the space after comma

[rbblue8]

thanks dude