Having a bit of a problem working out the best way to go about this...
A bit tricky to explain so I'll use an easier example to what I'm using.
Database has information on films, one table with the name, etc. As some films fit into multiple categories like action, animation etc there is a table which has the film categories which also contains a stregth for each film and category, then another table with the categories in them.
Probably a bit easier if I give you an example.
FILM
FilmID Name Director Release Date
CATEGORIES
categoryID Category
eg 1 animated
2 action
3 romance
FILMCATEGORY
filmcategoryID filmID categoryID strength
eg
1 1 1 50
2 1 2 50
Kind of means that the film is an animated action film.
Anyway onto my problem.
I've managed to display a table showing the films name, director, the name of the category and the strength.
I'm trying to display the filmcategory strengths for each film and show a zero if the film strength is not entered in the table. So far have only been able to show the informationfor the first film. Have no idea how to get it to move through each one and display the information for each one. So far what I have tried has just continuously shows the first films data over and over.
Really appreciate if you can offer some help. Just hope that I have made enough sense in describing the problem that someone can offer some help.
Thanks
