[RESOLVED] show/hide content with checkbox

[php_noob2]

Hi all,

I have a table of different picture albums and would to add a checkbox on the admin album page to show/hide albums to users. I have another table for users where the admin and normal users are kept.

As it is now I just show all with a simple query
$query = "SELECT name, blurb, path FROM album";

Could someone please let me know how to do this best? If there is a link to examples that would be great.

Thanks a lot! 🙂
php noob

---

OSX 10.5.3, PHP 5.2.5, MySQL 5.0.45

[leatherback]

You want to create a table with visible or something. In this table you store the ID value of the user & of the album that is visible:
[usernr][albumnr]
1 1
1 3
1 5

And you use a join to select the albums

select * from album left join visible on album.id=visible.albumnr where usernr = $userid

[php_noob2]

Awesome! Thanks, leatherback, I'll give it a try!