<div class="duyurular">
<ul id="announcement">
{php}
$result = mysql_query("SELECT * FROM tblannouncements WHERE published='on' ORDER BY date DESC LIMIT 0, 6");
$duyurular = array();
$i = 0;
while($data1 = mysql_fetch_array($result))
{
$i++;
$duyurular[$i]['id'] = $data1["id"];
$duyurular[$i]['date'] = $data1["date"];
$duyurular[$i]['title'] = $data1["title"];
$duyurular[$i]['announcement'] = $data1["announcement"];
}
{/php}
{php} foreach($duyurular as $key => $duyuru) { {/php}
<li><a href="announcements.php?id={php} echo $duyuru['id'] {/php}">{php} echo $duyuru['title'] {/php} - {php} echo $duyuru['date'] {/php}</a></li>
{php} } {/php}
</ul>
</div>
<!--duyurular--> <div class="duyurular">
<ul id="announcement">
{php}
$query = "SELECT * FROM tblannouncements WHERE published='on' ORDER BY date DESC LIMIT 0,3";
$result = mysql_query($query);
while ($data = mysql_fetch_array($result)) {
$id = $data["id"];
$date = $data["date"];
$title = $data["title"];
$announcement = $data["announcement"];
$date = fromMySQLDate($date);
echo '<li><a href="announcements.php?id='.$id.'">'.$title.' - '.$date.'</a></li>';
}
{/php}
</ul>
</div>
<!--duyurular-->