Adding data - more than one piece in a column?
View Single Post
01-25-2008, 01:03 PM
Join Date: Nov 2007
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.
Of course the whole point of a doomsday machine, would have been lost if you keep it a secret.
The Following User Says Thank You to EyeDentify For This Useful Post:
View Public Profile
Send a private message to EyeDentify
Find More Posts by EyeDentify