สอบถามเรื่องการดึงข้อมูลขึ้นมาโชว์แบบ 2 มิติค่ะ ตอนนี้ติดตรงวันที่แสดงซ้ำกันค่ะ

$data['11-07']['A1'] = 96;
$data['11-07']['A6'] = 98;
$data['11-07']['A7'] = 0;
$data['11-07']['A8'] = 0;
$data['11-07']['A10'] = 0;

foreach($data as $key=>$col){

    echo "<tr><td>$key</td><td>" . implode("</td><td>", $col) . "</td></tr>";
}

while($row = mysql_fetch_assoc($qry)){
    //$data['11-07']['A1'] = 96;
    $data[$row['date']][$row['id_area']] = $row['survival'];
}

<?php
$column = array('A1', 'A2', 'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9', 'A10');

$data['11-07']['A1'] = 96;
$data['10-07']['A6'] = 99;
$data['11-07']['A7'] = 98;
$data['10-07']['A1'] = 97;
$data['09-07']['A1'] = 98;

asort($data);

echo '<table border="1">';
echo '<tr>';
echo '<th>DATE</th><th>'. implode('</th><th>', $column). '</th>';
echo '</tr>';
foreach($data as $date=>$arr){

    echo '<tr>';
	echo '<td>' . $date . '</td>';
	foreach($column as $key){
		$survival = isset($arr[$key]) ? $arr[$key] : 0;
		if($survival > 0) $survival = '<div style="background-color:yellow">' . $survival . '</div>';
		echo '<td>' . $survival  . '</td>';
	}
	echo '</tr>';
}
echo '</table>';

?>

$sql = "SELECT id_area,date, SUM(survival) AS survival from even ";
$sql .= " GROUP by date,id_area ";

while($row = mysql_fetch_assoc($rsValue)){
    //$data['11-07']['A1'] = 96;
    $data[$row['date']][$row['id_area']] = $row['survival'];
}

$column = array('A1', 'A2', 'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9', 'A10');

$column = array('A1', 'A2', 'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9', 'A10');

//ค้นหา id_area เพื่อเอามาเป็นคอลัมน์
$arrAreaName = array();
$arrAreaId = array();
$sql = "SELECT `id_area`,`name_pond` FROM tb_area ";
$qry = mysql_query($sql) or die("Select error : ".mysql_error());
while($row = mysql_fetch_assoc($qry)){
	$arrAreaName[$row['id_area']] = $row['name_pond'];
}
$arrAreaId = array_keys($arrAreaName);

//echo '<pre>' . print_r($arrAreaName, true). '</pre>';

//ข้อมูลรายงาน
$sql = "SELECT `id_area`,`date`, `survival` FROM even ";
$sql.= " GROUP by `date`,`id_area`";
$rsValue = mysql_query($sql) or die("Select error : ".mysql_error());
while($ListValue = mysql_fetch_assoc($rsValue)){
	$data[$ListValue['date']][$ListValue['id_area']] = $ListValue['survival'];
}

//echo '<pre>' . print_r($data, true). '</pre>';

echo '<table border="1">';
echo '<tr>';
echo '<th>DATE</th><th>'. implode('</th><th>', $arrAreaName). '</th>';
echo '</tr>';
foreach($data as $date=>$arr){
	echo '<tr>';
	echo '<td>' . $date . '</td>';
	foreach($arrAreaId as $idArea){
		$survival = isset($arr[$idArea]) ? $arr[$idArea] : 0;
		if($survival > 0) $survival = '<div style="background-color:yellow">' . $survival . '</div>';
		echo '<td>' . $survival . '</td>';
	}
	echo '</tr>';
}
echo '</table>';