use the MySQL FORMAT function:
FORMAT(number to format, number of decimal places)
for 2 decimal places:
SELECT FORMAT(AVG(rating), 2) AS averageRating FROM table
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.