function &getJobbyId($job_id)
{
	$db = &$this->getDBO();
	if (is_numeric($job_id) == false) return false;
	$query = "SELECT job.*, cat.cat_title, company.name as companyname, jobtype.title AS jobtypetitle
		, jobstatus.title AS jobstatustitle, shift.title as shifttitle
		, department.name AS departmentname
		, salaryfrom.rangestart AS salaryfrom, salaryto.rangestart AS salaryto, salarytype.title AS salarytype
		, education.title AS educationtitle ,mineducation.title AS mineducationtitle, maxeducation.title AS maxeducationtitle
		, experience.title AS experiencetitle ,minexperience.title AS minexperiencetitle, maxexperience.title AS maxexperiencetitle
		, country.name AS countryname, state.name AS statename, county.name AS countyname, city.name AS cityname
		, company.logoisfile, company.logofilename

<div>
<?php if ($this->job->logoisfile !=-1) { ?>
	<img width="200"  src="<?php echo $this->config['data_directory'];?>/data/employer/comp_<?php echo $this->company->id;?>/logo/<?php echo $this->job->logofilename;?>" />
	<?php }else { ?>
	<img width="200" height="54" src="components/com_jsjobs/images/blank_logo.png" />
	<?php } ?>
</div>