| :: BigBeer Poll สรุปผลคะแนน :: | $PollTotal = SumPollVote( $sID );
$strSQL = "SELECT s.*, i.* "; $strSQL .= "FROM tbl_subject AS s, tbl_item AS i "; $strSQL .= "WHERE s.sID=i.sID "; $strSQL .= "AND s.sID=$sID";
$res = mysql_query( $strSQL );
while ( $rs = mysql_fetch_array( $res ) ) { $iVote = $rs[iVote]; if ( $PollTotal == 0 ) $CalPercent = 0; else $CalPercent = ( $rs[iVote] / $PollTotal ) * 100;
echo "\n"; echo "| $rs[iTitle] | \n"; echo ""; echo " "; echo "($iVote)"; echo " | \n"; echo ""; echo number_format( $CalPercent, 2, '.', ',' ); echo "% | \n"; echo " \n"; }
CloseDB(); ?> | | [รวมทั้งหมด ท่าน] | |