[SOLVED] Complicated Select query

[Clinton]

I didn't think it was that complicated but everytime I add another variable it seems to not work. This time it's the state variable. I added it and my query is pretending like it's not there and displaying the rest of the result. ANy ideas?

 

$sql = "SELECT * FROM $tbl_name WHERE dtype = '$dtype' OR dtypewc = '$dtype' AND dmajorp = '$smajor' OR dmajorc1 = '$smajor' OR dmajorc2 = '$smajor' OR dmajorc3 = '$smajor' AND state = '$state' ORDER BY jpted LIMIT $start, $limit";

[gevans]

You're mixing OR and AND you need to bracket off some parts of it as it makes sense to you ()

[Clinton]

Thanks Gevans, that worked. Now one more question. If the state variable hasn't been selected I want them to be able to view all states. Do I have to do an if isset statement or can I use a * or a wildcard variable of somesort? I've tried both * and % to no avail.

[flyhoney]

Maybe this:

 

WHERE ... (state = '$state OR state LIKE '%%') ...

[cytech]

 

 

$state_where = "";
if(!empty($state)){
    $state_where = " AND state = {$state}";
}

$sql = "SELECT * FROM $tbl_name WHERE dtype = '$dtype' OR dtypewc = '$dtype' AND dmajorp = '$smajor' OR dmajorc1 = '$smajor' OR dmajorc2 = '$smajor' OR dmajorc3 = '$smajor' {$state_where} ORDER BY jpted LIMIT $start, $limit";

 

Thats how I would go about it.

 

[Clinton]

Thanks Cy, that worked perfectly.