HAVING in Select statment

[beyondflash]

I have multiple items that I don't want selected in my select statement...I can get ONE to work here is a sample:

$sql = "SELECT * FROM login
WHERE (Email = '$email') HAVING Crsnum != 1 ORDER BY ID DESC";

This will not select any Crsnum that =1...
The problem I am having is I have multiple crsnum's that cannot be selected example:

1,4,9,17,19

How do I create the SELECT statement to omit those index numbers from being selected??

Thanks.

 

[DotNetGnat]

may be you need to use IN key word...

WHERE Crsnum IN (1,4,9,17,19)

-DNG

 

[TonyGroves]

Or even:
[tt]
WHERE crsnum NOT IN (1,4,9,17,19)
[/tt]

 

[beyondflash]

when I add a second WHERE I get an sql error msg

$sql = "SELECT * FROM login
WHERE (Email = '$email')
WHERE crsnum NOT IN (1,4,9,17,19)
ORDER BY ID DESC";

 

[TonyGroves]

You must use:
[tt]
WHERE email='$email' AND crsnum ...
[/tt]

 

[DotNetGnat]

should be like this...

WHERE CONDITION1 AND CONDITION2

-DNG

 

[beyondflash]

Thank you