<table border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td>News</td>
		<td>Jan</td>
		<td>Feb</td>
		<td>Mar</td>
		<td>Apr</td>
		<td>May</td>
		<td>June</td>
		<td>July</td>
		<td>Aug</td>
		<td>Sep</td>
		<td>Oct</td>
		<td>Nov</td>
		<td>Dec</td>
	</tr>
<?php
$query="select date_format(newsDate,'%Y') as `News_Year`,newsDate from news_table group by `News_Year`";
$result=mysql_query($query);
while($row=mysql_fetch_array($result))
{
?>
	<tr>
		<td><?php echo $row['News_Year'];?></td>
		
<?php
	for($i=0;$i < 12;$i++)
	{
		$date=explode('-',date("Y-01-d"));
		$checkdate=date("Y-m",mktime(0,0,0,$date[1]+$i,$date[2],$date[0]));
		$query2="select date_format(newsDate,'%Y-%m') as `News_Year` from news_table where `News_Year` = '".$checkdate."'";
		$result2=mysql_query($query2);
		if(mysql_num_rows($result2) > 0)
		{
?>
			<td>X</td>
<?php
		}else{
?>
			<td>&nbsp;</td>
<?php
		}
	}	
?>
	</tr>
<?php
}
?>
</table>

Edited by - Roddy Dairion on 30 Mar 2010  15:33:13