There are no errors coming up, just not displaying the jobs from the sql database, i think what the guy said first of all is correct. here is some of tthe code to the page.
<?php
function main( )
{
include( "language.php" );
$memid = mysql_real_escape_string( $_SESSION['memid'] );
$js_postjob = mysql_fetch_array( mysql_query( "select * from post_resume where js_id='{$memid}'" ) );
$keyword = mysql_real_escape_string( $_REQUEST['keyword'] );
$title = mysql_real_escape_string( $_REQUEST['title'] );
$job_code = mysql_real_escape_string( $_REQUEST['job_code'] );
$skills = mysql_real_escape_string( $_REQUEST['skills'] );
$exp1 = mysql_real_escape_string( $_REQUEST['exp1'] );
$expexact = mysql_real_escape_string( $_REQUEST['expexact'] );
$qualif = mysql_real_escape_string( $_REQUEST['qualif'] );
$country = mysql_real_escape_string( $_REQUEST['country'] );
$stateid = mysql_real_escape_string( $_REQUEST['T7'] );
$cityid = mysql_real_escape_string( $_REQUEST['T8'] );
$state_select = mysql_fetch_array( mysql_query( "select * from state where sta_id='{$stateid}'" ) );
$city_select = mysql_fetch_array( mysql_query( "select * from city where cit_id='{$cityid}'" ) );
$state = $state_select['sta_name'];
$city = $city_select['cit_name'];
$location = $city_select['cit_name'];
$role = mysql_real_escape_string( $_REQUEST['role'] );
$employer = mysql_real_escape_string( $_REQUEST['employer'] );
$employertype = mysql_real_escape_string( $_REQUEST['employertype'] );
$period = mysql_real_escape_string( $_REQUEST['period'] );
$today = date( "Y-m-d" );
$period_days = $period;
$EXday = date( "d", mktime( 0, 0, 0, 0, date( d ) - $period_days, 0 ) );
$EXmonth = date( "m", mktime( 0, 0, 0, date( m ), date( d ) - $period_days, 0 ) );
$EXyear = date( "Y", mktime( 0, 0, 0, date( m ), date( d ) - $period_days, date( Y ) ) );
$total_period_days = "{$EXyear}-{$EXmonth}-{$EXday}";
$rs0 = mysql_fetch_array( mysql_query( "select * from zw_websetting" ) );
$jsplan = $rs0['jsplan'];
$js_select = mysql_fetch_array( mysql_query( "select * from job_seeker where id='{$memid}'" ) );
$js_plan_select = mysql_fetch_array( mysql_query( "select * from js_plan where js_planid='{$js_select['js_plancode']}'" ) );
$pagelimits = $rs0['noofrecords'];
$start = mysql_real_escape_string( $_REQUEST['start'] );
$end = mysql_real_escape_string( $_REQUEST['end'] );
if ( !$start )
{
$start = 1;
}
$lim = $rs0['num_page_numbers'];
if ( !$end )
{
$end = $lim;
}
$records_per_page = $pagelimits;
if ( isset( $_REQUEST['cur_page'] ) )
{
$page_num = $_REQUEST['cur_page'] + 1;
}
else
{
$page_num = $cur_page + 1;
}
$str = "select * from employer emp, jobposting jp where emp.status='active' and emp.memvalidity>='{$today}' and jp.validity >='{$today}' and jp.status ='active' and emp.emp_id=jp.empid";
$page_query = "";
if ( $keyword != "" )
{
$page_query .= "&&keyword={$keyword}";
$str .= " and jp.summary like '%{$keyword}%'";
$_SESSION['key'] = $keyword;
}
if ( $title != "" )
{
$page_query .= "&&title={$title}";
$str .= " and jp.title like '%{$title}%'";
$_SESSION['titles'] = $title;
}
if ( $job_code != "" )
{
$page_query .= "&&job_code={$job_code}";
$str .= " and jp.jobcode = '{$job_code}'";
$_SESSION['job_code'] = $job_code;
}
if ( $skills != "" )
{
$page_query .= "&&skills={$skills}";
$str .= " and jp.skills like '%{$skills}%'";
$_SESSION['skill'] = $skills;
}
if ( $qualif != "" )
{
$page_query .= "&&qualif={$qualif}";
$str .= " and jp.qual = '{$qualif}'";
$_SESSION['qualify'] = $qualif;
}
if ( $country != "" )
{
$page_query .= "&&country={$country}";
$str .= " and jp.jobcountry = '{$country}'";
$_SESSION['country'] = $country;
}
if ( $state != "" )
{
$page_query .= "&&state={$state}";
$str .= " and jp.jobstate like '%{$state}%'";
}
$_SESSION['search_state'] = $state;
if ( $city != "" )
{
$page_query .= "&&city={$city}";
$str .= " and jp.jobcity like '%{$city}%'";
$_SESSION['search_city'] = $city;
}
if ( $role != "" )
{
$page_query .= "&&role={$role}";
$str .= " and jp.jobrole like '%{$role}%'";
}
if ( $employer != "" )
{
$page_query .= "&&employer={$employer}";
$str .= " and emp.compname like '%{$employer}%'";
$_SESSION['employer'] = $employer;
}
if ( $employertype != "" )
{
$page_query .= "&&employertype={$employertype}";
$str .= " and emp.comptype='{$employertype}'";
$_SESSION['employertype'] = $employertype;
}
if ( $period != "" )
{
$page_query .= "&&period={$period}";
$str .= " and jp.posteddate >='{$total_period_days}'";
$_SESSION['period'] = $total_period_days;
}
if ( $exp1 != "" )
{
$page_query .= "&&exp1={$exp1}";
if ( $expexact == "exact" )
{
$page_query .= "&&expexact={$expexact}";
$str .= " and jp.minexp='{$exp1}'";
}
else
{
$str .= " and jp.minexp<='{$exp1}'";
}
}
$_SESSION['str'] = $str;
$str .= " group by jp.id";
if ( !( $str = mysql_query( $str ) ) )
{
exit( mysql_error( ) );
}
$cur_page = $_REQUEST['cur_page'];
$str_num = mysql_num_rows( $str );
$query_data = mysql_fetch_array( $str );
$total_num_page = ceil( mysql_num_rows( $str ) / $records_per_page );
if ( $total_num_page < $lim )
{
$lim = $total_num_page;
}
if ( $total_num_page < $end )
{
$end = $total_num_page;
}
if ( empty( "cur_page" ) )
{
$cur_page = 0;
}
$limit_str = "LIMIT ".$cur_page * $records_per_page.",{$records_per_page}";
$query_postjobs = "select * from employer emp, jobposting jp where emp.status='active' and emp.memvalidity>='{$today}' and jp.validity >='{$today}' and jp.status ='active' and emp.emp_id=jp.empid";
if ( $keyword != "" )
{
$query_postjobs .= " and jp.summary like '%{$keyword}%'";
}
if ( $title != "" )
{
$query_postjobs .= " and jp.title like '%{$title}%'";
}
if ( $job_code != "" )
{
$query_postjobs .= " and jp.jobcode='{$job_code}'";
}
if ( $skills != "" )
{
$query_postjobs .= " and jp.skills like '%{$skills}%'";
}
if ( $qualif != "" )
{
$query_postjobs .= " and jp.qual = '{$qualif}'";
}
if ( $country != "" )
{
$query_postjobs .= " and jp.jobcountry = '{$country}'";
}
if ( $state != "" )
{
$query_postjobs .= " and jp.jobstate like '%{$state}%'";
}
if ( $city != "" )
{
$query_postjobs .= " and jp.jobcity like '%{$city}%'";
}
if ( $role != "" )
{
$query_postjobs .= " and jp.jobrole like '%{$role}%'";
}
if ( $employer != "" )
{
$query_postjobs .= " and emp.compname like '%{$employer}%'";
}
if ( $employertype != "" )
{
$query_postjobs .= " and emp.comptype='{$employertype}'";
}
if ( $period != "" )
{
$query_postjobs .= " and jp.posteddate >='{$total_period_days}'";
}
if ( $exp1 != "" )
{
if ( $expexact == "exact" )
{
$query_postjobs .= " and jp.minexp='{$exp1}'";
}
else
{
$query_postjobs .= " and jp.minexp<='{$exp1}'";
}
}
$query_postjobs .= " group by jp.id order by id desc {$limit_str}";
if ( !( $query_postjobs = mysql_query( $query_postjobs ) ) )
{
exit( mysql_error( ) );
}
;
