/home/mip/public_html_/old-website/old/jobs.php
<? require_once("func_proc.php");
do_html_header();
do_menu();

$jobs = getdata("select * from webjobs where posting_date <= '$sqltoday' and (closing_date > '$sqltoday' or closing_date='0000-00-00') order by closing_date desc");
$num_jobs = count($jobs);
$col1 = ceil($num_jobs/2);
echo mysql_error();


?>
     
			<!--call do_leftContent-->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
             
			  <tr>
                <td height="3px"></td>
              </tr>
              <!--<tr>
                <td height="1" background="images/pixel.gif"><img src="images/pixel.gif" width="1" height="1"></td>
				
              </tr>-->
              <tr>
                <td style="padding:10px;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td>
	
                     
					<!-- V00.13, Edited by jeric NoV. 2007 (start job seekers update resume) --> 
					
					
					<table border="0" cellpadding="3" cellspacing="0" width="100%">
					
					<tr height="5"  bgcolor="">
					<td colspan="2"></td>
					</tr>
					

		<tr height="5"  bgcolor=>
				<td colspan="2"></td>
					</tr>
					
					
					 <form action="apply_online.php" method="post" name="log">
					 <input type="hidden" name="action" value="update">
					
					<tr>
					<td colspan="2" align="center">&nbsp;</td>
					</tr>
					</form>
					
					<!-- V00.13, Edited by jeric NoV. 2007 (end of job seekers update resume) --> 
						<tr>
					<td width="120" class="header_white" bgcolor="#999999" style="padding-top:3;padding-left:5px;">
					<b> Job Openings </b>					</td>
					<td>&nbsp;					</td>
					</tr><tr height="5"  bgcolor="#999999">
					<td colspan="2"></td>
					</tr>
					</table>
					<br />
		 <table width=100% border="0" cellpadding="0" cellspacing="0" bgcolor="#cccccc">
			
		
		
		<tr><td valign="top">
				<table width=100% border="0" cellpadding="0" cellspacing="0" bgcolor="#cccccc">
				  <tr>
					    <td height=23>&nbsp;<b>Position</b></td>
							<td>&nbsp;<b>Country</b></td>
							<td>&nbsp;<b>Date Posted</b></td>
					</tr>
					<?for($i=1;$i<=$num_jobs;$i++){?>
					<tr  bgcolor="#ffffff" onMouseover="this.bgColor='#f1f1f1'" onmouseout="this.bgColor='#ffffff'"><td height="23">&nbsp;<a href="page_job.php?webjob_id=<?=$jobs[$i][webjob_id]?>"><?=getname($jobs[$i][position_id],"positions","position_id")?></a></td>
							<td height="23">&nbsp;<?=getname($jobs[$i]['country_id'],"country","country_id")?></td>
							<td height="23">&nbsp;<?=dateformat($jobs[$i]['posting_date'])?></td>
					</tr>
					<?}?>
				  </table>
					</td>
					
			  </tr>
	</table>				
					
	             
					</td>
                  </tr>
                 
                </table></td>
              </tr>
            </table>
	            <!--RIGHT CONTAINER-->
				<? //do_job_openings($jobs); ?>
<? do_footer();?>