Tell database records it can display?

[ost87]

Hi Everyone

This supremeley difficult, or am I wrong?

I have a CMS system with several different components (such as business directory, classifieds system and forum) , all of which are calling for information from the database.

I would like to introduce some kind of code that would be linked up to a popup list. Based on the selection in the popup list, some records in the database would be made unavailable to the site.

I would like to achieve this functionality without modifying any of the components or programming for any of the different components, I just want to add code.

So, basically what I’m looking for is a piece of code that tells the database what records can be made available ( or unavailable ) to the site. This should be irrespective of the content and programming of the site.

I’ve attached an image of this functionality, which should give you the conceptual view.

I really hope that somebody knows how to murder this problem.

[littleFella]

There is no info about any of the existing code or table structure of relevant records, so I doubt anybody would be in a position to offer a solution that would work for sure.

Even if you show what you already have, you mays still need to modify some code. Some marvelous stuff can be done in code, but if you have a substantial body of code in place then don't expect miracles - some of the stuff will have to be changed.

[Mrblogs]

Well you would need to add a field to the tables, such as "Visible", and then your pop-up list would set visibles to 0 or 1 depending on what you select.

Finally, you would need to modify the SELECT statements to include the "WHERE Visible=1" into the statements

[ost87]

Hi Littlefella and thanks for your response.

I agree that the information I have provided is not sufficient enoguh so that any one could provide a solution for my site specifically.

The problem is, as I see it, very complex and not easy to explain.

I think this problem will need a miracle, maybe there some genius out there.


But let me put it like this;
what I want is a piece of code that tells the database which records can be made available to the site.
This should be independent of the components. The components behave in the same way, only the amount records that are available is a subset.

In practice it's like deleting records from database, so the result is a subset, only the records are not deleted, only hidden in some way.


I think it's possible, if my explanation is clear enough (which I doubt, it took me a couple of days to get my dad to understand), for users to provide a general solution or give some kind of indication how to do it.

thanks for your help, I do believe in miracles( even when my dad is concerned)

[Mrblogs]

Instead of adding fields to the database then,

create a table with "Field ID", "TypeofField" and then a Visible tag.

Field ID will be the ID of the row in the particular table, that TypeOfField will decide. VIsible then will link to that.

It will still require a modification of the SQL on the site however to link in "where fieldID=table.ID and TypeofField=1 and visible=1"

etc