Posted by anonymous on 07/16/07 00:57

Usually I get a answer in alt.php concerning MYSQL :-) :-)

I've reposted the question below, I have a very large and complex
environment, and this is just the thing I need to do. Can someone
please show a working example? How does the explode() command help me
pull back #5 data slot? Thank you for your patience and anyone can
help that would be great.


-----------

Hello, could someone please show me how to do this.

In a single cell in a DB column, I can have multiple kinds of data
squeezed together delimited by a comma.

like .....
"datagreen,datablue,dataorange,datawhite,datayellow,datared,datablue, ...
"

If I read that data and have it in a string like $datastring...... how
do I put it into a array situation? to access that data.... so if I
want to know what is in spot 5 only, and return back 'datayellow' for
instance, how do I do that? :-) I don't know if array is the right
word, I just want to be able to access any part of that string based
on the order it is in.

Thank you!

Rebecca

[Back to original message]