title: Integrating a 1-10 voting system effectively without common pitfalls
body: <p>I'm planning on integrating a reasonable ranking/voting system into an existing application.</p>
  
  <p>I'm familiar with how the traditional 5 star rating systems work and know the <a href="http://www.evanmiller.org/how-not-to-sort-by-average-rating.html" rel="nofollow">common pitfalls/problems</a> associated with them therefore was wondering if there is other ways (I've heard of Wilsons, Bayesian etc. but not really sure on how to implement this with the below structure):</p>
  
  <ul>
  <li>I'm planning on allowing users to vote on content between 1 to 10 via the contents page.</li>
  <li>The score and total votes for that content will be displayed on the contents page.</li>
  <li>I will also be displaying/listing the Top 10 Content so I'd need the method to be fair/realistic and not make a vote of 10 with total votes of 1 to go straight to number 1.</li>
  </ul>
  
  <p>I'm using <code>PHP</code> and <code>MySQL</code>, I have a table for the content (which has a <code>content_id</code> which I guess I can <code>JOIN</code> on).</p>
  
  <p>I'm wondering if you can suggest a way/method which achieves the above, I'd appreciate if you can attach some example PHP code and example MySQL schema so I can better understand it, as I've google'd and may have found potential solutions such as Wilsons and Bayesian...yet they provide a lengthy article with confusing mathematical equations - and mention no way which achieves the above (ie. the score....and implenting the method in PHP/MySQL) or atleast due to there not being any example PHP/MySQL code me misunderstanding this.</p>
  
  <p>Perhaps this is easier then I think - I don't know as I've never had the need to implement this sort of "more complex" ranking/voting functionality before - so I'd appreciate your responses.</p>