Posted by Jerry Stuckle on 07/16/07 00:41

rebeccatre@gmail.com wrote:
>
> 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
>

Rebecca,

Try this in comp.databases.mysql - a MySQL newsgroup.

But before you do, google for "database normalization". MySQL has a
decent discussion on it, but some other sites may be better.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: Question about reading data I've created with , delimiter
• Prev in forum: Question about reading data I've created with , delimiter
• Thread view: Re: Question about reading data I've created with , delimiter

[Reply to this message]