This is something I've been asked to look at creating. At the moment the site has a database back end storing details of a few hundred holiday properties. So that part is already set up.
So I'm familiar enough with databases etc, but less so the formulas and any additional database structure for any voting.
It would be pretty simple, ie visitors could vote 1, 2, 3 4, or 5 stars for any property.
There needs to be a total score recorded somewhere for each property.
And the site needs to display the average score for that property.
Any pointers on this much would be much appreciated.
Consider my wrist duly slapped.
Yes, Google is an excellent resource, although in my experience for many things such as this a search will return 101 different ways of doing something, many of which will do, or explain, 80% of what you need.
So sometimes posting on a forum is better for getting a recommendation from someone for a good tutorial on something.
Sure - posting on a forum is always better. But with a question like this, you are also likely to get 101 different ways of doing it as well! No wrist slap was really intended.
When I did that search and looked at the first 5 hits, it seemed that the answers were spot on for you.
True enough. I think that it involved introducing formulas made it a little daunting, but looking at a few sites, it hopefully isn't too complicated.
First step I guess is to create a ratings table, get that working, and then get on to the calculations part.