rendered paste body<?php
$sql="select jobid, jobtitle, jobcode from jobposting where category = 'thera' and dateactive < $currentdate and active = 'yes'";
$query=mysql_query($sql);
if ($row=@mysql_fetch_array($query)){
do {
?>
<p><a class="jobgrn" href="joblisting.php?jobid=<?echo $row['jobid'];?>"><?echo $row['jobtitle'];?></a><br>
<span class="jobcodewht">JOB CODE: <?echo $row['jobcode'];?></span><br>
<?
} while ($row=@mysql_fetch_array($query));
} else {
?>
<p>No listings at this time<br>
<?
}
?>