$value) {
$$key = addslashes($value);
}
//make sessions from posts
$_SESSION['SEARCH']['KEY'] = $keyword;
$_SESSION['SEARCH']['SALARY'] = $salary;
$_SESSION['SEARCH']['DAYS'] = $days;
$_SESSION['SEARCH']['AREA'] = $area;
}
if ($_GET['page']>0){
//if record page then call sessions
if($_SESSION['SEARCH']['KEY'] != '') $keyword = $_SESSION['SEARCH']['KEY'];
if($_SESSION['SEARCH']['SALARY'] != '') $salary = $_SESSION['SEARCH']['SALARY'];
if($_SESSION['SEARCH']['DAYS'] != '') $days = $_SESSION['SEARCH']['DAYS'];
if($_SESSION['SEARCH']['AREA'] != '') $area = $_SESSION['SEARCH']['AREA'];
}
/*
SELECT * FROM Persons WHERE
(FirstName='Tove' OR FirstName='Stephen')
AND LastName='Svendson
*/
if($_GET['submitted']>0 || $_GET['page']>0){
$sql = "SELECT * FROM jobpost WHERE job_WebsiteID LIKE '%thebook%' AND ";
if ($keyword != "") $sql.="(job_Industry LIKE '%$keyword%' OR job_LocationPart1 LIKE '%$keyword%' OR job_LocationPart2 LIKE '%$keyword%' OR job_JobTitle LIKE '%$keyword%' OR job_Description LIKE '%$keyword%') AND ";
if ($salary != "") $sql .= $salary." AND ";
if($latest == 1){
$sql.= "(job_LocationPart1 LIKE '$area' OR job_LocationPart2 LIKE '$area') AND DATE_SUB(CURDATE(),INTERVAL ".$days." DAY) <= job_Timestamp";
} else {
$sql.= "(job_LocationPart1 LIKE '$area' OR job_LocationPart2 LIKE '$area')";
}
// $sql.= " AND job_realEmail LIKE '%thebook%'";
//echo $sql;
$result = $item->execute($sql);
if($result){
$num = mysql_num_rows($result);
if($num>0) $item = db_result_to_array($result);
}
}
?>
Specialists in creative recruitment : the book : pure creative recruitment : creative job search
The Book pure creative recruitment is one of the North of England's leading creative recruitment consultancies.
We offer freelance and permanent recruitment for the following roles: Creative Directors, Art Directors, Designers, Artworkers, Visualisers, Retouchers, Illustrators, Copywriters,, Editors, Proofreaders, Studio Managers, Production Managers, Traffic Co-ordinators, E-commerce Managers, Web Designers, Multi Media Designers, Web Content Managers, Flash Designers, Web Developers, HTML Coders, PHP Coders, Actionscript Coders, ASP Coders, Information Architects, E-Learning Professionals, Web Testers
