I am building a web site. I want a page where a club administrator can see the list of the clubs they are authorized to view. I have three tables;
clubs - a table listing all clubs - relevant columns are club_id (PK), club_name,club_www, address1, address2, www_facebook, phone_number, fax_number, city, club_twitter, club_facebook, country, region
club_member_roles - role_id(PK), role_name, member_id, club_id,member_status
club_facilities - club_id, pool, fitness_centre, restaurant, meeting_room, etc.
Region contains 'AFRICA' or 'NORTH AMERICA' or 'EUROPE'
I would like to list all clubs where the joomla user (member_id = joomla user_id) has role_name 'Administrator' and member_status='Approved'.
Then allow the administrator to select a club from the list and update the club's details such as club_www, address1, address2, www_facebook, phone_number, fax_number, city, club_twitter, club_facebook.
Then another button to display the club facilities and use checkboxes to update each facility. On or off. Column type for each facility column is varchar(1) 'Y' or 'N'.
Hi, I have more than 3 years of experience with joomla and it's extension and i am able to solved your problem with module. for my detail portfolio check your PMB. Thanks...