"; ?> Aquista.com Latest Vacancies http://www.aquista.com/rss Latest vacancies from aquista.com en-gb &copy; aquista limited 2011 http://www.aquista.com/rss 15 Aquista.com http://www.aquista.com/assets/1/aquista_logo.gif http://www.aquista.com loadTableDefinitions(); $tabledef=new dbTableDefinitions(); $dbObj=new db(); $dbObj->opendbconnection(); $sql="SELECT uID,jobtitle,refNo,salary,content,displayFrom,company,logo,remuneration,dispCompName,location FROM vacancies where displayTo > UNIX_TIMESTAMP() AND displayFrom < UNIX_TIMESTAMP() ORDER BY uID DESC LIMIT 200"; #echo $sql; $dbObj->setsql($sql); $dbObj->selectquery(); $y=0; #print_r($dbObj->result); if(isset($dbObj->result)){ for($x=0;$xresult);$x++){ #preg_match_all('/]+>/i',$dbObj->result[$x][2], $images); $y++; $title=preg_replace("/\s&\s/"," and ",strip_tags($dbObj->result[$x][1])); $joblocation = $dbObj->result[$x][1]; $title=htmlspecialchars(htmlentities($title)); $title.=" [".$dbObj->result[$x][2]."]"; $date=date("D, d M Y G:i:s \G\M\T",time()); $dcdate=date("D, d M Y 08:30:s \G\M\T",$dbObj->result[$x][5]); $description=preg_replace("/float: right;\"/","float: right;\" align=\"right\" ",$dbObj->result[$x][4]); $description=preg_replace("/float: left;\"/","float: left;\" align=\"left\" ",$description); #$description=strip_tags($description); //$description=$description; #$description=html_entity_decode(html_entity_decode($description)); #$description=str_replace("\n","",$description); #$description=preg_replace("/£/","£",$description); #$description=preg_replace("/’/","'",$description); #$description=preg_replace("/&/","&",$description); #$description=preg_replace("/&amp;/","&",$description); #$description=str_replace("\r","<br />",$description); $description=htmlspecialchars(nl2br($description)); $title=preg_replace("/&amp;/","&",$title); $salary=str_replace("£","£",$dbObj->result[$x][3]); $remuneration=str_replace("£","£",$dbObj->result[$x][8]); if($remuneration!=""){$salary=$remuneration;} $dispCompName=$dbObj->result[$x][9]; $company=""; if($dispCompName==0){ $company="Company: ".$dbObj->result[$x][6]."
";} $id=$dbObj->result[$x][0]; $jobRef=$dbObj->result[$x][2]; $logo=""; $logoFile=$dbObj->result[$x][7]; if($logoFile!=""){ $logo="

"; $logo=html_entity_decode(html_entity_decode($logo)); } $logo=htmlspecialchars($logo); #$jobTerm=$tabledef->nameFromID($dbObj->result[$x][6],"recJobTypes"); $jobTerm=$dbObj->result[$x][6]; $jobTerm="
Company Name: <strong>$jobTerm </strong>"; # Out put the xml echo" $title $dcdate http://www.aquista.com/search_results.html?showJob=yes&uID=$id $company Reference: $jobRef
Salary: $salary
".substr($description,0,500)."... ]]>
http://www.aquista.com/search_results.html?showJob=yes&uID=$id&section=vacancies Aquista Ltd uID0$id Business Article $dcdate
"; } } # https://v3.aquista.com/search_results.html?showJob=yes&id=$id§ion=vacancies # Reference:<strong> $jobRef </strong> <br />Location: <strong>$jobLocation </strong> <br />Salary: <strong>$salary </strong> <br />Business Area: <strong>$busAreaName</strong>$jobTerm <br /><br />$description # $date # http://v3.aquista.com/search_results.html?showJob=yes&id=$id§ion=vacancies # Aquista Ltd # Business # $dcdate # Article # uID0$id ?>