TalkPHP - View Single Post - Adding data

Brook · 01-25-2008, 07:22 AM

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?)

01-25-2008, 07:22 AM	#3 (permalink)
Brook The Acquainted Join Date: Jul 2005 Location: UK Posts: 121 Thanks: 41	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?) __________________ PS3 Forums on GameSlurp - the site for gaming fans!