[thelist] an array of values in a MySQL table?

[Edward Shuck]

Hi
First time responder, been lurking for about a month.

I use php and mysql.  One of the ways I use php is on my neighborhood page.
Shops and Items with a category in the middle that is capable of many to
many using the _id field from the Shops fiels and the Items field.  Works
like this:
shop_id shop
1           xyz bar
2           supermarket
3           meat market

category
shop_id    item_id
1              5
2              5
3              2
2              2
2              3
item
item_id item
1          soap
2          meat
3          cereal
4          video rental
5          beer

peace
----- Original Message -----
From: "phil" <phil at xlab.co.uk>
To: <thelist at lists.evolt.org>
Sent: Tuesday, March 27, 2001 7:50 AM
Subject: [thelist] an array of values in a MySQL table?


> Is it possible to store an array of values in a field within a row of a
> MySQL database table?
>
> The scenario is that I have news articles in a table (news_tbl) which are
> pigeon-holed using values from another table (issue_tbl).
>
> Each news article may apply to one or more type of issue (as listed in
> issue_tbl) so I thought an array of values would work, but I'm not sure if
> it's possible, and if so, how to begin.
>
> The issues are drawn from a separate table to allow new issues to be added
> and edited in the future, without affecting the news_tbl.
>
> any thoughts?
>
> cheers,
>
> phil
>
>
> --
>
> http://www.xlab.co.uk
>
> design | web | music | football
>
>
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>