I am putting together a video tape database (for japanese anime videos). The database holds the title, info on the back, length in minutes, and some extra information used for my script.
What I would like to do is have an area at the bottem of the page that lists 5 other videos that are in the same series. Sort of like on amazon.com or other sites like that which show you other things related to a product.
So if the video Ranma 1/2 Movie 1 is being displayed (which has a seriesName value of "ranma" in the database), I want 5 other ranma videos at the bottem of the page (just a text link). How would I go about listing only 5 ranma videos, none of those listed being duplicate records, and none of those listed being the video currently displayed. So if Ranma 1/2 Movie 1 is being displayed, I don't want the same video to appear as a text link at the bottem. Nor do I want 2 instances of "Ranma 1/2 Movie 2" in the text link area.
Any ideas? I already have the script displaying text links for ALL the ranma videos, but I want it more defined as I already explained.
What I would like to do is have an area at the bottem of the page that lists 5 other videos that are in the same series. Sort of like on amazon.com or other sites like that which show you other things related to a product.
So if the video Ranma 1/2 Movie 1 is being displayed (which has a seriesName value of "ranma" in the database), I want 5 other ranma videos at the bottem of the page (just a text link). How would I go about listing only 5 ranma videos, none of those listed being duplicate records, and none of those listed being the video currently displayed. So if Ranma 1/2 Movie 1 is being displayed, I don't want the same video to appear as a text link at the bottem. Nor do I want 2 instances of "Ranma 1/2 Movie 2" in the text link area.
Any ideas? I already have the script displaying text links for ALL the ranma videos, but I want it more defined as I already explained.