MySQL SELECT question...

[brianb]

hey all,

How would I write this?

SELECT News WHERE

themeID=$themeID
AND/OR
themeID2=$themeID
AND/OR
themeID3=$themeID

AND category !=5

Make sense? I have themes that different news items get attached to. On the themes page I want to display any news that that theme would have attached.

So, say I have theme 345 called up.

Then in my news table, there is an item that looks like this:

themeID=247
themeID2=345
themeID3=842

I want the headline of that news to show upon my theme page becuase themeID2 = the theme ID I've called.

Any help is appreciated. I just can't figure out how to write the SELECT.

Thanks.

[sarahk]

SELECT News
from myTable
WHERE (themeID=$themeID
or themeID2=$themeID
or themeID3=$themeID)
AND category !=5