Adding data - more than one piece in a column?
View Single Post
01-25-2008, 07:23 AM
Join Date: Dec 2007
Originally Posted by
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?)
Hmm, I just started learning more MySQL, so I don't really know how to tell you this :[ Sorry..
"The reasonable man adapts himself to the conditions that surround him... The unreasonable man adapts surrounding conditions to himself... All progress depends on the unreasonable man." - George Bernard Shaw
The Following User Says Thank You to Orc For This Useful Post:
View Public Profile
Send a private message to Orc
Visit Orc's homepage!
Find More Posts by Orc