Regex... damn you

I have been trying to get the letter search function for searching film titles working but a combination of the way I want to make it work and have it all working in a stored procedure has been causing hassle. Basically I was using a regex in a stored procedure bt it had to be dynamic based on which letter the person wants to search for. I had kinda gave up trying to get it to work in the stored procedure as it would work in sql on the page or in a function but not in a stored procedure. It was only when I got a duh moment this evening that it dawned on my why it wasnt working. I was trying to apply something dynamic into something that was set i.e. when i was naming the variable in the regex it was using the name of the variable the not the value. So to get around this I had to concatenate the regex so the variable would be its valuable not its string name. Jobe done!!!

I have also went ahead and built the year page, so it produces a table filled with all the years that have films tagged to them and shows the amount of films that year has. It only shows years that there are films for so if there are none for say 2000 then 2000 does not show up. In addition to this on specific year pages i.e. the break down of a year showing the films made during it, I have added two options at the top of the table, which show you the next year with films on it and the previous year with films on it. so say you were on 1990 and the next year up with films tagged to it was 91 that shows but say there were none for 89 but some for 88 then 88 shows up as the previous year. This should make it easier for people to jump between years instead of having to know a specific year.