# Is my query correct?

**URL:** <https://forum.kirupa.com/t/is-my-query-correct/299445>\
**Category:** Uncategorized\
**Created:** [November 5, 2009, 7:51am UTC](https://forum.kirupa.com/t/is-my-query-correct/299445 "2009-11-05T07:51:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![utsav](https://avatars.discourse-cdn.com/v4/letter/u/e19b73/32.png) [@utsav](https://forum.kirupa.com/u/utsav)\
**Post date:** [November 5, 2009, 7:51am UTC](https://forum.kirupa.com/t/is-my-query-correct/299445/1 "2009-11-05T07:51:25Z")

</div>

I have written the following query:

```php

$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` = '%'";
                    }

```

```auto

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.

```auto

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?