/home/mip/public_html_/old-website/archive.php
<?
require_once("func_proc.php");
do_header("Announcements");
do_menu();
if($year) $sqlyear = "and Year(posting_date) = '$year'";
if($month) $sqlmonth = "and Month(posting_date) = '$month'";
// nextback
$sites = getdata("select count(*) from web_announcements where 1 and status = 'Published' $sqlyear $sqlmonth");
$total=$sites[1][0];
$range=15;
$next_back=next_back($total,$range,$page,"$PHP_SELF?year=$year&month=$month");
$start=$next_back[0];
// nextback
$ann = getdata("select * from web_announcements where 1 and status = 'Published' $sqlyear $sqlmonth order by posting_date desc, title asc limit $start,$range");
$num_ann = count($ann);
?>
<p><span style="padding:20px;"><img src="images/announce.gif" /></span></p>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="585" valign="top" style="padding-left:25px; padding-right:20px; padding-top:0px;">
<table width=100% border="0" cellpadding="0" cellspacing="0">
<form action="<?=$PHP_SELF?>#search" method="post">
<tr>
<td style="padding-top:20px; padding-bottom:20px; padding-right:0px;" align="center" colspan="2">
<div style="padding-top:3px; padding-bottom:3px;">
<?
$a = date('Y',strtotime("-5 year"));
$b = date('Y');
$months = array("01","02","03","04","05","06","07","08","09","10","11","12");
?>
<font color="#FFFFFF"><b>Month:</b></font>
<select name="month">
<option value="">--Select Month--</option>
<?selectcodemonth($months,$month)?>
</select>
<font color="#FFFFFF"><b>Year:</b></font>
<select name="year">
<option value="">--Select Year--</option>
<? for($c=$b;$c>=$a;$c--) {?>
<option value="<?=$c?>" <? if($year==$c) {?> selected="selected" <? }?>><?=$c?></option>
<? } ?>
</select>
<input type="submit" name="search" value="Search" />
</div>
</td>
</tr>
</form>
<tr><td valign="top" class="morejobs_item">
<?
if($num_ann) {
for($j=1;$j<=$num_ann;$j++){ ?>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr><td style="padding-bottom:15px;" class="style3">
<div style="font-size:12px;">
<img src="images/b_let.jpg" width="9" height="10" border="0"/>
<b><?=dateformat($ann[$j][posting_date])?></b></font></div>
<div style="padding-left:18px;"><a href="announcements.php?id=<?=$ann[$j][id]?>" title="<?=$ann[$j][title]?>" class="data"><?=$ann[$j][title]?></a></div>
<div style="padding-left:18px;"><?=substr(strip_tags($ann[$j][announcement]),0,150)?>...</div>
</td></tr>
</table>
<? } } else { ?>
<div align="center" style="color:#FF0000; padding:10px;"><b>No Record Found</b></div>
<? } ?>
</td></tr>
<? if($num_ann) { ?>
<tr>
<td align="center" style="padding-top:10px; padding-bottom:15px;" class="style3"><?=$next_back[1]?></td>
</tr>
<? } ?>
</table>
</td>
</tr>
</table>
<? do_footer(); ?>