Fixes and updates

I did a little bit more work on the admin section today and fixed a few things that annoyed me, one being that when you submitted edits on a film in the ful film list view it took you back to the home view. I have now sorted this so it knows to go back to the all film index (only does this for film details edit, will add this to genres edit as well soon). On top of this I also added a little bit of functionality to this so that when you go back you get bounced down the page to where the film is you just edited. That way the more films you add you don't have to keeps scrolling down all the time.

I also added in the ability to tag if I own the film, I was swithering about this one but decided to go for it. Even if it doesnt make its way onto the main pages of the site, does it matter it is there and it is logging. I also went back and filled in that info for all the films I have currently in the database.

The insert or update mysql query I talked about in my last update for the admin section to do with film genre's. I have found a solution that doesn't involve relying on the use of keys in the table as that wouldnt work for this issue. The solution is a little more confusing but it works at least. The solution I found was to set up the insert as you would but then use a combination of a select and where not exsists to query the table and see if the (non key) values already exist. That way it takes out the autoincirment id key which is what I was looking for and saves me doing a db call to check first then based on that result inserting or not.