Originally posted by Adam The thing is that in the reviews, there is also a field for price. A lot of the features and facilities you asked for above are already there. So, in essence, your lens review db is used for much more than mere opinions.
If you want to write a script that polls data from each lens in the database and computes further averages, be my guest. However, I still think that the price field in the lens reviews provides an accurate picture of trends and average pricing.
As far as cameras go, however, it's another story. As much as I'd like average pricing and rating to be part of the camera review database, that hasn't been possible to implement at the moment- though I'll gladly do it in the future if an accessible method of doing so shows itself.
On the pricing, not knowing how frequently the prices are recalculated, I would assume to create a rolling average of either the last 12 prices posted or the past 12-months or whatever time frame would simply be to add a filter or conditional based on whatever the today() function is called in, what is this PHP?, and only those reviews with prices that fall within the desired period or quantity are used in the calculation.
Then again given the world wide participation here, and the huge variation of price around the globe for a lens, it might all sort of even out anyway. So....never mind...hehehehe...see I talked myself out of the idea.