I'm having a bit of an issue, in the real world there's an economy of goods and prices, an ever changing one, The average price on a jar of honey may be $3 today but in 4 days it could be $3.25, everything changes constantly, is there a way where i could do something like this with tables? I want to be able to let users put in what the think a good price for the item would be and it takes the other prices and averages them automatically and displays the price. For example,
I have listed an apple, the starting value of the apple is $3
User 1 thinks the apple is worth around $4
($4 + $3)x .5 = $3.50 (Average cost of an Apple)
This price is now displayed to the community, that the average price of an apple is $3.50, now say another user comes around,
User 2 thinks the apple is somewhere around $2.75
($4 + $3 + $2.75) x .5 = $4.87
Now, the average price of an apple that would be displayed to the community is $4.87, is there something like this that i could use on my website? Whether it is open source or not doesn't matter, something that will check the MySQL databases for previous data and average out the information/prices/data to give an end average price between the submitted prices?
I've been having quite some trouble with this issue, i'm looking to create a price guide for online items in a gaming community, is there an easy way to do this?