# PHP SQL help

**URL:** <https://forum.kirupa.com/t/php-sql-help/205011>\
**Category:** programming\
**Created:** [October 25, 2006, 11:29am UTC](https://forum.kirupa.com/t/php-sql-help/205011 "2006-10-25T11:29:46Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![opel](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/opel/32/199_2.png) [@opel](https://forum.kirupa.com/u/opel)\
**Post date:** [October 25, 2006, 11:29am UTC](https://forum.kirupa.com/t/php-sql-help/205011/1 "2006-10-25T11:29:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![evildrummer](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/evildrummer/32/2308_2.png) [@evildrummer](https://forum.kirupa.com/u/evildrummer)\
**Post date:** [October 25, 2006, 11:37am UTC](https://forum.kirupa.com/t/php-sql-help/205011/2 "2006-10-25T11:37:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![evildrummer](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/evildrummer/32/2308_2.png) [@evildrummer](https://forum.kirupa.com/u/evildrummer)\
**Post date:** [October 25, 2006, 11:36am UTC](https://forum.kirupa.com/t/php-sql-help/205011/3 "2006-10-25T11:36:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![skOOb](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@skOOb](https://forum.kirupa.com/u/skOOb)\
**Post date:** [October 25, 2006, 12:06pm UTC](https://forum.kirupa.com/t/php-sql-help/205011/4 "2006-10-25T12:06:52Z")

</div>

```auto
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.

---

<div class="post-metadata">

**Author:** ![opel](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/opel/32/199_2.png) [@opel](https://forum.kirupa.com/u/opel)\
**Post date:** [October 25, 2006, 12:07pm UTC](https://forum.kirupa.com/t/php-sql-help/205011/5 "2006-10-25T12:07:43Z")

</div>

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

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

or

!= ‘2,3,4’

Cheers for fast reply

---

<div class="post-metadata">

**Author:** ![opel](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/opel/32/199_2.png) [@opel](https://forum.kirupa.com/u/opel)\
**Post date:** [October 25, 2006, 12:22pm UTC](https://forum.kirupa.com/t/php-sql-help/205011/6 "2006-10-25T12:22:01Z")

</div>

[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.

---

<div class="post-metadata">

**Author:** ![skOOb](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@skOOb](https://forum.kirupa.com/u/skOOb)\
**Post date:** [October 25, 2006, 12:52pm UTC](https://forum.kirupa.com/t/php-sql-help/205011/7 "2006-10-25T12:52:05Z")

</div>

did that work for you then?

---

<div class="post-metadata">

**Author:** ![opel](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/opel/32/199_2.png) [@opel](https://forum.kirupa.com/u/opel)\
**Post date:** [October 25, 2006, 12:56pm UTC](https://forum.kirupa.com/t/php-sql-help/205011/8 "2006-10-25T12:56:01Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![bwh2](https://avatars.discourse-cdn.com/v4/letter/b/8c91f0/32.png) [@bwh2](https://forum.kirupa.com/u/bwh2)\
**Post date:** [October 25, 2006, 1:45pm UTC](https://forum.kirupa.com/t/php-sql-help/205011/9 "2006-10-25T13:45:19Z")

</div>

sk00b’s NOT IN method is the answer.

---

<div class="post-metadata">

**Author:** ![evildrummer](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/evildrummer/32/2308_2.png) [@evildrummer](https://forum.kirupa.com/u/evildrummer)\
**Post date:** [October 25, 2006, 5:51pm UTC](https://forum.kirupa.com/t/php-sql-help/205011/10 "2006-10-25T17:51:55Z")

</div>

I was guessing with the !=

---

<div class="post-metadata">

**Author:** ![bwh2](https://avatars.discourse-cdn.com/v4/letter/b/8c91f0/32.png) [@bwh2](https://forum.kirupa.com/u/bwh2)\
**Post date:** [October 25, 2006, 6:07pm UTC](https://forum.kirupa.com/t/php-sql-help/205011/11 "2006-10-25T18:07:05Z")

</div>

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