quoteable as hell

After not working on the site for a little bit other than adding new films, I have added 2 bits of functionality yesterday, both at this point in time on the admin section. First off I spotted an issue with one of the films that I had tagged genre's to and it was showing a double set of the same ones. This is because I had two windows open and submitted both with the same items (or so I think) thus proving there is no real error detection on that part of the input, so for the short term I have amended the view on the film lists to show how many genre's are tagged to a film. I am also working on a solution to prevent this that wont involve re-coding that functionality.

The other thing I did was to add a new piece of info for each film, a quote from the film. Now not every film will have one of these as some films don't have good quotes or I may not want to add one so I created a new table for this instead of adding a new field into the main film table. Then linked this to the other tables. This means that I am only storing items that are needed and not having unused space for many films that won't have quotes. I also built the admin functionality for this and ran into a couple of issues which were easily sorted when I worked out what was going wrong. I did build this so you cant add duplicates or secondary items and built this into the sql itself. I was going to use this method for the other issue above but due to unique keys it is not possible for that.

I am also mulling over the idea of adding in a little bit more functionality to the admin, so that when I tag a film I can also tag if I own it or not. This woudl be easily added in and I woudl add this directly to the film's main table as every film with either be a yes or no. But we will wait and see on that one.