Query problem

[Anon]

Hi there,
Can anyone tell me the best solution to the following problem?
Lets say i have an admin page where i insert values into the DB. These values are categories. On the form that inserts the category values i have a checkbox system. Depending on what i check will result in whats displayed on a page.
For example, if the category name is "Car" and i check "Global" from the check box system then i want this value to show up on all pages. If i insert the value "Bike" and check the box "Local" i want all the "Global" values to display as well as those values that are "Local" (the Local values will display depending on a users login).
I basically want the "Global" value to always display but the "Local" value to display only if a certain user has entered.

Regards,
maccam

[pnoeric]

maccam, that's kind of a vague description of the problem, so I can only give you a vague answer. this might help, though, just in how you're thinking about the situation and maybe it will solve your (specific) problem.

essentially, you have two separate things to do here: one is process a form with checkboxes and store the data in the database, and the other is to read those values from the database later and change the display on the page based on what you retrieve.

THE BEST POSSIBLE WAY TO APPROACH THIS IS TO TACKLE THOSE TWO PROBLEMS SEPARATELY.

so first, get your form set up with the checkboxes etc and be sure it is putting the right info into the database. period. done.

then, go to the display page and have it read the values from the db and work with them as appropriate.

like I said, vague, but hope it helps. if you can get more detailed I can try to help further.

best
Eric