<?php
// Retrieve data from database
$sql="SELECT id,naziv,datum_objave,hit_count FROM obavjestenja WHERE godina='2012' order by id ASC";
$result=mysql_query($sql);
// Define $color=1
$color="1";
echo '<table width="665" border="0" align="center" cellpadding="0" cellspacing="1" class="tabtext">';
while($rows=mysql_fetch_array($result)){
// If $color==1 table row color = #FFFFFF
if($color==1){
echo "<tr height='20' bgcolor='#FFFFFF'>
<td width='35' align='left' valign='middle'>".$rows['id']."</td>
<td width='' align='left' valign='middle'>".$rows['naziv']."</td>
<td width='120' align='left' valign='middle'>".$rows['datum_objave']."</td>
<td width='50' align='center' valign='middle'><a href='obavjestenja/2012/pdf/".$rows['id'].".pdf' target='_blank'><img src=grafika/PDF.png width='16' height='16' class='bezokvira'/></a></td>
<td width='120' align='left' valign='middle'>".$rows['hit_count']."</td>
</tr>";
// Set $color==2, for switching to other color
$color="2";
}
// When $color not equal 1, use this table row color
else {
echo "<tr height='20' bgcolor='#F0F0F0'>
<td width='35' align='left' valign='middle'>".$rows['id']."</td>
<td width='' align='left' valign='middle'>".$rows['naziv']."</td>
<td width='120' align='left' valign='middle'>".$rows['datum_objave']."</td>
<td width='50' align='center' valign='middle'><a href='obavjestenja/2012/pdf/".$rows['id'].".pdf' target='_blank'><img src=grafika/PDF.png width='16' height='16' class='bezokvira'/></a></td>
<td width='120' align='left' valign='middle'>".$rows['hit_count']."</td>
</tr>";
// Set $color back to 1
$color="1";
}
}
echo '</table>';
mysql_close();
?>