I'm sure my explanations are confusing...maybe a look at my structure will help. Maybe what I'm asking can't be done or my db structure is incorrect.
venue_user_access table:
userID | venueID
116 | 65
116 | 66
114 | 65
etc | etc
venues table:
venueID | venueMasterID | venueName | other columns with venue info
65 | 113 | My Club | blah blah blah etc
66 | 113 | Club 2 | blah blah
The page I'm doing this query on is a page to update the user's (in my test case userID 116) access to clubs owned by venueMasterID 113. On the insert page I used one of the extensions (can't remember which one) to repeat and insert some checkboxes that contained the clubs owned by venueMasterID 113. Now I would like to generate the checkboxes on the update user page based on clubs owned by venueMasterID 113 and have the ones that userID 116 has access to show up as checked and the other ones unchecked.
Seems like a simple doable thing, but it's been a hair puller haha.
Again, the help is certainly appreciated.
-Twitch