Adding data - more than one piece in a column?
View Single Post
01-25-2008, 07:22 AM
Join Date: Jul 2005
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?
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?)
on GameSlurp - the site for gaming fans!
View Public Profile
Send a private message to Brook
Find More Posts by Brook