simple sql selec help. AND type <>('dev, hl')";

[aron]

$sql = "SELECT * FROM listings WHERE status<>'sold' AND type <>('dev, hl')";

help with the above please.

cheers aron.

[tekky]

I think you want this?

$sql = "SELECT * FROM listings WHERE status<>'sold' AND type NOT IN ('dev, hl')";

[herve]

You should use the NOT IN operator
instead of the <>, ie :

$sql = "SELECT * FROM listings WHERE status<>'sold' AND type NOT IN ('dev, hl')";

[aron]

hmm dosent work.

[sidney]

a classic case of compounded errors caused by copy and paste lol

$sql = "SELECT * FROM listings WHERE status<>'sold' AND type NOT IN ('dev, hl')"; 

shouldbe

$sql = "SELECT * FROM listings WHERE status<>'sold' AND type NOT IN ('dev', 'hl')";
   

[herve]

Sorry ...

$sql = "SELECT * FROM listings WHERE status<>'sold' AND type NOT IN ('dev', 'hl')";