I have written the following query:
$edu = $_POST['edu'];
if($edu == "SLC")
{
$for = "`slc` != ''";
}
elseif($edu == "+2")
{
$for = "`inter` != ''";
}
elseif($edu == "Bachelor")
{
$for = "`bachelor` != '' or `edu1` like 'b%' or `edu2` like 'b%'";
}
elseif($edu == "Master")
{
$for = "`master` != '' or `edu1` like 'm%' or `edu2` like 'm%'";
}
elseif($edu == "Phd")
{
$for = "`edu1` like '%phd%' or `edu2` like '%phd%'";
}
if($edu == "ANY")
{
$for = "`slc` = '%'";
}
select * from resumes where $for and SUM(exp1months + exp2months + exp3months) as ex >= $exp1 like '%$exp1%' and `interest` like '%$interest1%' and status = 1 order by id desc
This query gives me thsi result when i echo it.
select * from resumes where `bachelor` != '' or `edu1` like 'b%' or `edu2` like 'b%' and SUM(`exp1months` + `exp2months` + `exp3months`) as `ex` >= 2 like '%2%' and `interest` like '%%' and status = 1 order by id desc
And returns no result.
Can you tell me where am i going Wrong?