จะแยกตารางตามปีค่ะ เก็บข้อมูลเป็นรายปี ตอนนี้ select ข้อมูลออกมาแสดงทุกปีเลยค่ะ

<?
include("conn.php") ;
$sql = "SELECT * FROM course WHERE dept_id='$dept_id' ORDER BY course_year DESC " ;
$sqlquery=mysql_db_query($dbname, $sql); 
?>
	

<table width="960" border="0" cellspacing="" cellpadding="4" align="center">
<tr>
<td height="30" bgcolor="black"><DIV align="center"><span class=style8>Course Year</span></div></td>
<td height="30" bgcolor="black"><DIV align="center"><span class=style8>Course Code</span></div></td>
<td height="30" bgcolor="black"><DIV align="center"><span class=style8>Course Name</span></div></td>
<td height="30" bgcolor="black"><DIV align="center"><span class=style8>Course Session</span></div></td>
<td height="30" bgcolor="black"><DIV align="center"><span class=style8>Course Date</span></div></td>
<td height="30" bgcolor="black"><DIV align="center"><span class=style8>Course Type</span></div></td>
<td height="30" bgcolor="black"><DIV align="center"><span class=style8>Course Position</span></div></td>
<td height="30" bgcolor="black"><DIV align="center"><span class=style8>File Upload</span></div></td>
<td height="30" bgcolor="black"><DIV align="center"><span class=style8>Course Status</span></div></td>
</tr>
		<?

		while($row=mysql_fetch_row($sqlquery))
			{
		
		?>
<tr>
<td><div align="center"><span class=style3><?=$row[4]?></div></span></td>
<td><div align="center"><span class=style3><?=$row[13]?></div></span></td>
<td><div align="left">&nbsp;<span class=style3><?=$row[2]?></div></span></td>
<td><div align="center"><span class=style3><?=$row[14]?></div></span></td>
<td><div align="center"><span class=style3><?=$row[3]?></div></span></td>
<td><div align="left">&nbsp;<span class=style3><?=$row[5]?></div></span></td>
<td><div align="left">&nbsp;<span class=style3><?=$row[6]?></div></span></td>
<td><div align="center"><span class=style3><?=$row[xx]?></div></span></td>
<td><div align="center"><span class=style3><?=$row[12]?></div></span></td>
</tr>
		<?
		}
		?>
		</table>
		<?

		mysql_close();
?>