/home/mip/public_html_/old_mip/jobs.php
<? require_once( "func-all.php");
do_header();
$sqltoday = date('Y-m-d');
$jobs = getdata("select web_jobs.*,positions.name,country.name as cname from web_jobs,positions,country where 1 and positions.position_id = web_jobs.position_id and web_jobs.country_id = country.country_id $sql_jname and ('$sqltoday' >= web_jobs.posting_date AND '$sqltoday' < web_jobs.expiry_date) and web_jobs.status = 'Open' order by order_id");
?>
<div class="inner-header">
<img src="images/img-inner-header-apply.jpg" class="img-responsive"/>
</div>
<div class="container">
<div class="row">
<div class="col-sm-12">
<h3>Job Openings</h3>
<table class="table table-hover table-striped">
<thead>
<th>#</th>
<th>Position</th>
<th>Country</th>
<th>Date Open</th>
</thead>
<tbody>
<?php foreach ($jobs as $key => $job) { ?>
<tr>
<td><?php echo $key; ?></td>
<td><?php echo $job['name']; ?></td>
<td><?php echo $job['cname']; ?></td>
<td><?php echo dateformat($job['posting_date']); ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<?php
do_employerlogin();
do_footer();
?>