/home/mip/mip/public/img/credit/datatables/archive.php.tar
home/mip/public_html_/old-website/archive.php000064400000005565151520616520015310 0ustar00<? 
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>&nbsp;
			<select name="month">
				<option value="">--Select Month--</option>
				<?selectcodemonth($months,$month)?>
			</select>
			&nbsp;
			<font color="#FFFFFF"><b>Year:</b></font>&nbsp;
			<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>
			&nbsp;
			<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(); ?>
Path: home/mip/mip/public/img/credit/datatables