Loop เดือนเดียวกันให้มาแสดงแถวกันครับ แต่คอมลัมคนละปี กันครับ

	$sql1 = "select *,DATE_FORMAT(date, '%m' ) as m from sale_date where DATE_FORMAT(date, '%m' ) = $month ";
	$query1 = mysql_query($sql1) or die(mysql_error());
	while ($fetch1 = mysql_fetch_array($query1)){
			$id1 = $fetch1['ID'];
	$sql = "select *,DATE_FORMAT(date, '%Y-%m-%d' )
			from sale_date where shop_pos = '".$shop_pos."'  and id = '".$id1."'
			Group by  DATE_FORMAT(date, '%Y' ) " ;
		$query = mysql_query($sql) or die(mysql_error());
		while ($fetch = mysql_fetch_array($query)){
			$id = $fetch['ID'];
			$amonth = $fetch['amount'];
			$allday = $fetch['date'];
			$Ye = $fetch['Ye'];
	echo "<tr>";
    echo"	<td>$allday </td>";
	echo "<td>$amonth</td>";
	echo "<td></td>";	
	echo "<td></td>";		
	} 		
}