[SOLVED] Where Query

[iceblox]

Hi Guys not sure if im being blonde but im having issues with the following query;

 

                if($_GET['NetworkName'] == "") {
                $net = "NetworkName <> 'Pay As You Go' AND NetworkName <> 'SIM Free' AND";
                }
                elseif($_GET['NetworkName'] == "All") {
                $net = "";
                }
                elseif($_GET['NetworkName'] == "PAYG") {
                $net = "NetworkName = 'Pay As You Go' OR NetworkName = 'SIM Free' AND";
                }
                elseif($_GET['NetworkName'] == "Monthly") {
                $net = "NetworkName <> 'Pay As You Go' AND NetworkName <> 'SIM Free' AND";
                }
                else {
                $net = "NetworkName = '$_GET[NetworkName]' AND ";
	}

Basically when NetworkName = PAYG it shows every row with either Pay As You Go or SIM Free in them ignoring other if queries which state a paticular modelid. If this makes sense? I have tried AND and this shows no results at all.

[craygo]

have you tried putting it in parenthesis around it

$net = "(NetworkName = 'Pay As You Go' OR NetworkName = 'SIM Free') AND";

 

Also echo out your query before you run it and see what it says.

 

Ray

[iceblox]

Thanks craygo,

 

Worked a treat