<?include $_SERVER['DOCUMENT_ROOT']."/admin/adminTopMenu.html";?>

<div id="contents"> 
	<h2>설문조사</h2>
	<div>
	<table width="400" summary="관리자모드 게시판입니다" cellspacing="0" >
		<colgroup>
			
			<col width="250"/>
			<col />		
		</colgroup>
 		<thead>
			<tr>
				<th>설문</th>
				<th style="text-align:left;">총계</th>
			</tr>
		</thead>
		<tbody>
		
 <?
// =============================================== Query
$QUERY_PAGE = "
SELECT goods1, count( goods1 ) as cnt 
FROM AUCTION_EVENT2
GROUP BY goods1
union all
SELECT goods2, count( goods2 ) as cnt
FROM AUCTION_EVENT2
GROUP BY goods2
union all
SELECT goods3, count( goods3 ) as cnt
FROM AUCTION_EVENT2
GROUP BY goods3
";
$result= mysql_query($QUERY_PAGE,$db_con);

$goodArr1 = array("航空券パッケージ","ホテルパッケージ");
$goodArr2 = array("2人","1人");
$goodArr3 = array("","羽田","成田","中部","関西","福岡","札幌","千歳","新潟","岡山","広島","その他");
$i =1;
while($row= mysql_fetch_array($result)){
	$goodName="";
	switch($i){
		case "1":
			$goodName = $goodArr1[0];break;
		case "2":
			$goodName = $goodArr1[1];break;
		case "3":
			$goodName = $goodArr2[0];break;
		case "4":
			$goodName = $goodArr2[1];break;
	}
	if($i >= 5){
			for($k=1; $k<=11; $k++) {
			if($row[goods1] == $k) $goodName = $goodArr3[$k];
			}
	}
?>
<tr>
	
	<td><?=$goodName?></td>
	<td style="text-align:left;"><?=$row[cnt]?></td>
</tr>
<?
	//$cntArr[] =$row[cnt];
$i++;
}
		
?>
			
		</tbody>
		</table>
</div>
<p></p>
</body>
</html>