Nope, the SQL query I suggested earlier is incorrect because it biases the display by AVG of votes already. You do need to divide the average by all votes, as suggested by Mark.
In what environment do you want to use this Ian? Can it not be done with two queries...if it is in some programming language for instance? In which case you dont need the temporary variable of "totalVotes" in Mark's example.. Shanx --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
