View Single Post
Old 01-25-2008, 01:03 PM   #8 (permalink)
EyeDentify
The Acquainted
 
EyeDentify's Avatar
 
Join Date: Nov 2007
Location: Sweden
Posts: 106
Thanks: 13
EyeDentify is on a distinguished road
Default

Why not use a relations table to hook up actors with a movie.

Lets say you have your actor table with:

ID | firstname | lastname | info

And your movie table:

ID | title | info

And your relations table where the actors get related to a movie.
ID | movie_ID | actor_ID

so for every actor you would want to link to a movie you just make a row entry in the relation table containing the "movie_ID" of the movie and the "actor_ID" of the actor who should be related to that movie.

And ofcourse you would have to construct a mechanism that would take the movie ID when the movie details page is called and use that movie_ID to query the relation table for all the rows containg a matching movie_ID.
Then take all the actor_ID:s that would be the outcome from that query and then list the actors getting the individual actors Info from the actor_ID itself while listing them.

Did that sound complicated ?, well at first i would say it sounds scary. but i think this approach would bring more flexibility to the handling of information.

Thats my opinion anyway.

Good Luck to ya.

/EyeDentify
__________________
Of course the whole point of a doomsday machine, would have been lost if you keep it a secret.
EyeDentify is offline  
Reply With Quote
The Following User Says Thank You to EyeDentify For This Useful Post:
Brook (01-25-2008)