retrieving multiple values

[Anon]

Hi all,

Let me first explain what I have set up already and then you can tell me if there is a better/easier way to do this:

I have a table of articles for an e-zine and each article will have several related mps's listed underneath. So in the admin section when editing/creating the article you also have a multiple select list of all mp3 files (taken from another table) and you select the songs you want to appear on that article by holding down the ctrl button and then using arrays I save those values in the database.

So for each article record, I have a field where I've saved the ID's of the selected mp3 records using commas e.g. 1,45,22,4,67,34,45....

What I want to know is how do I now retrieve these values and select the right mp3 records using these ids? I can spilt them and create an array but then what? how do I select and list only these records on the article page?

I hope that all made sense.

Autumnnn

[simonsky]

not sure what do you want to do with these IDs?

however, storing 1,45,22,.....in a database field is not a good way in database management. A more common way is to use a table to store the user ID and the mp3 id :
UserID mp3ID
1 1
1 45
1 22
2 3
3 23
.....

then you may select what you what by a select * from table where UserID=1

Simonsky

[theeper]

Try using explode()

http://www.php.net/manual/en/function.explode.php