$strQuery = mysql_query("
SELECT *, AVG(AVERAGE) AS AVG,count(MEMBER_ID)AS CNT
FROM evaluation_result,project
WHERE evaluation_result.PROJECT_ID=project.PROJECT_ID
GROUP BY evaluation_result.PROJECT_ID") or die("mysql_error");
$strQuery = mysql_query("SELECT *,round( AVG(AVERAGE),1) AS AVG,count(MEMBER_ID)AS CNT FROM evaluation_result,project
WHERE evaluation_result.PROJECT_ID=project.PROJECT_ID GROUP BY evaluation_result.PROJECT_ID") or die("mysql_error");
Load balance : Server 03
