MySQL Query

[*MO*]

Hi Everyone. I've got a problem with an SQL query. I'm gonna try my best to explain the structure and the problem i'm having.

I've got 2 tables. one is called 'articles', and the other is called 'sections'
the articles table has a foreign key called sectionsID which will be the same as the secions.id.

Now the sections table also has a field that specifies if the section is hidden or not. field is called sections.hidden and is an enum of 'Y', and 'N'.

so i can say :
SELECT articles.* FROM articles,sections WHERE sections.hidden = 'N'

easy

but the articles.sectionID can store more than one sections ID. ie: 3-4
which means, that this article is in section 3 and section 4.

however, section 3 is hidden. 4 is NOT hidden.

but when i do a query to show all articles, i want it show this article, even tho its in 3 and is hidden, but because its in 4, it will be visible.
if it was JUST in section 3, then it would not show.

If its gonna make is easier, this is for a blog system. so you can understand what i'm trying to do.

Any help would really be great. Thank you

[*MO*]

K. Seemed to have fixed it.

I added another field to the end of the articles table, which specifies if the article is safe to show on all pages. when i do an insert or update, the script checks if the article will be part of a "Safe" section, and if it is, then it'll display. if its not part of a safe section, then it'll block it

regards,
Mo

[JacKDynne]

And that is what I was gonna suggest you do



/JD

[*MO*]

hehehe

thanx