Originally Posted by Brook

Hi Orc - thanks for the reply.

I probably didn't explain myself properly, but I was specifically referring the page where I want to list the actors associated with that movie. So for eg, on the link I posted above, (once I already have the database of actors set-up), how do I add them to movies they are in? And then how do I get mysql to know how to 'decode' the actor_ids?

EG:

Actors Column/field on Movie Page: 124,366,697,125,123

These are added to the movie page when the page is being created. So the person writing the page will simply enter the actor_ids of all the actors in that movie.

I need to know how to transform all those ids that are seperated by a comma into individually ids that I can feed into mysql via a query.

(Am I making any more sense?)