PHP SQL help

programming
1

I am trying to create a sql statement that will select all records EXCEPT for certain content ID that I will manually specify. I’m a newbie to PHP so not sure what the correct SQL statement would be : lmow it would be something like

“SELECT contentId, contentName,contentText, contentDisplay FROM content WHERE contentDisplay='Yes”…Need this bit to be where contentID is not equal to 1, 2, 3 etc "

Any help would be appreciated.

Cheers

2

you could try
SELECT * FROM content WHERE contentDisplay != '2' where 2 is the row is the one you DONT want to display

3

you could try
SELECT * FROM content WHERE contentDisplay != '2' where 2 is the row is the one you DONT want to display

4 
SELECT contentId, contentName,contentText, contentDisplay FROM content WHERE contentDisplay='Yes' AND contentID NOT IN (1, 2, 3, 4, 5)

You could just seperate the ID’s that you don’t want with commas and use the NOT IN listing.

5

if I want to add more thant one row would it be =

!= ‘2’,‘3’.‘4’

or

!= ‘2,3,4’

Cheers for fast reply

6

[QUOTE=opel;1985106]if I want to add more thant one row would it be =

!= ‘2’,‘3’.‘4’

or

!= ‘2,3,4’

Cheers for fast reply[/QUOTE]

sorry skoob never saw your reply. Seem to be having problems wit the board it is missing out topics and making me log in every time I want to see a page.

7

did that work for you then?

8

I’m at work at the moment I’ll try it over next couple of days when I get a chance and let you know. Thanks.

9

sk00b’s NOT IN method is the answer.

10

I was guessing with the !=

11

!= will work if you only want to exclude one value (at a time).