Title: Mushfiqur's Replies | WordPress.org --- # Mushfiqur [ ](https://wordpress.org/support/users/aa11plus/) * [Profile](https://wordpress.org/support/users/aa11plus/) * [Topics Started](https://wordpress.org/support/users/aa11plus/topics/) * [Replies Created](https://wordpress.org/support/users/aa11plus/replies/) * [Reviews Written](https://wordpress.org/support/users/aa11plus/reviews/) * [Topics Replied To](https://wordpress.org/support/users/aa11plus/replied-to/) * [Engagements](https://wordpress.org/support/users/aa11plus/engagements/) * [Favorites](https://wordpress.org/support/users/aa11plus/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 15 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] I want to count how many lessons of a subject a student has done](https://wordpress.org/support/topic/i-want-to-count-how-many-lessons-of-a-subject-a-student-has-done/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [2 years, 3 months ago](https://wordpress.org/support/topic/i-want-to-count-how-many-lessons-of-a-subject-a-student-has-done/#post-17744497) * Apologies, an addition: SELECT `aletheia_lesson_report`.`report_student` as ‘ Report_student’, `aletheia_lesson_report`.`report_subject` as ‘Report_subject’FROM` aletheia_lesson_report`WHERE (`aletheia_lesson_report`.`report_subject` = ‘Maths’) ORDER BY `aletheia_lesson_report`.`report_student` ascI’ve just worked out how to filter for a specific subject! - This reply was modified 2 years, 3 months ago by [Mushfiqur](https://wordpress.org/support/users/aa11plus/). - This reply was modified 2 years, 3 months ago by [Mushfiqur](https://wordpress.org/support/users/aa11plus/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] I want to count how many lessons of a subject a student has done](https://wordpress.org/support/topic/i-want-to-count-how-many-lessons-of-a-subject-a-student-has-done/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [2 years, 3 months ago](https://wordpress.org/support/topic/i-want-to-count-how-many-lessons-of-a-subject-a-student-has-done/#post-17744465) * Here’s my follow-up (lol). Bear in mind I don’t know much SQL: SELECT `aletheia_lesson_report`.` report_student` as ‘Report_student’, `aletheia_lesson_report`.`report_subject` as ‘Report_subject’FROM `aletheia_lesson_report`ORDER BY `aletheia_lesson_report`.` report_student` ascI’ve just used the table view and I’ve added the above. So, aletheia_lesson_report is the table and student and subject are columns in the table. I’ve got a view that now lists student name to subject. And as expected, I can see rows of student names (multiple rows for each student) with lots of rows with the same subject. Examples of subjects are: Biology, Chemistry, Physics, Maths, English. What should I do to return student name to subject count, please? For example there are five subjects above. So, I should see the student’s name 5 times and in each row I should see the subject column and a count column of how many subject rows there are for that student. Basically, how many times have they had Biology, Chemistry, Physics, Maths, English.The data comes from teachers inputting into the lesson report table what student they taught and what subject they taught the student. Would be extremely grateful if you could point me in the right direction. From the example in your link, I couldn’t work out how to adjust the count(empno) for my scenario. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] I want to count how many lessons of a subject a student has done](https://wordpress.org/support/topic/i-want-to-count-how-many-lessons-of-a-subject-a-student-has-done/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [2 years, 3 months ago](https://wordpress.org/support/topic/i-want-to-count-how-many-lessons-of-a-subject-a-student-has-done/#post-17743236) * Yes, it’s a bog standard WP Data Access table… Thanks, I’ll have a read of the Search Panes | WP Data Access pages and see if I can find what I need. Thans for the links! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] How to autofill listbox columns from one table to another](https://wordpress.org/support/topic/how-to-autofill-listbox-columns-from-one-table-to-another/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 6 months ago](https://wordpress.org/support/topic/how-to-autofill-listbox-columns-from-one-table-to-another/#post-12409681) * Yes, so the aa_student table has stud_id, wp_user_id and stud_fullname columns of which stud_id is the PK. The aa_test table (just for testing and learning) has test_id (PK), stud_id, wp_user_id and stud_fullname columns in there. * The reason I’m trying to pipe those columns from aa_student table (to all other tables) is so that, when I create any new table, the login user is able to view only their data and I don’t have to manually select the student’s/teacher’s wp_user ID every time I add an entry. * Because, the way I have understood it, the login user’s wp user ID must be present and matched to the WPDataAccess table PK of the student. Is that correct or is there a better, more efficient way? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] How to autofill listbox columns from one table to another](https://wordpress.org/support/topic/how-to-autofill-listbox-columns-from-one-table-to-another/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 6 months ago](https://wordpress.org/support/topic/how-to-autofill-listbox-columns-from-one-table-to-another/#post-12401670) * I’ve tried and I can’t get it working… * So, I’ve got one table (aa_student) and another table (aa_test). aa_student has many colums three of which are stud_id, wp_user_id and full name. aa_test has 4 columns: stud_id, wp_user_id, full name, note. * I gave both tables the same option set name (test01): * [Here are the tables](http://www.tutormychild.com/hallgreen/wp-content/uploads/2020/02/projecttables.png) * and created a parent/child page in Projects with the aa_test table being the chosen table: * [Here are the settings](http://www.tutormychild.com/hallgreen/wp-content/uploads/2020/02/projectpagesettings.png) * I added a lookup relationship. This worked and gave me a dropdown of all the students’s fullnames: * [Here is the lookup setup](http://www.tutormychild.com/hallgreen/wp-content/uploads/2020/02/relationshipsgoright.png) * But when I add the additional column lookups (as below) then the dropdown becomes empty and although I can click on a dropdown link, there are no student names in there. * [Here are all the lower lookup settings](http://www.tutormychild.com/hallgreen/wp-content/uploads/2020/02/relationshipsgonewrong.png) * What am I doing wrong? All I want to do is select a student name and have the data in that row to pipe across automatically and populate the same columns in the new table. * As always, your advice is most appreciated… * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Error on trying to add any table to PROJECTS: there has been a critical error on](https://wordpress.org/support/topic/error-on-trying-to-add-any-table-to-projects-there-has-been-a-critical-error-on/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 6 months ago](https://wordpress.org/support/topic/error-on-trying-to-add-any-table-to-projects-there-has-been-a-critical-error-on/#post-12386029) * Thanks Peter, I’m back in action! Appreciate you sorting it out so quickly ( for all of us). * ps. I’ve put a little something into your donation box… * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] How to create a class register…](https://wordpress.org/support/topic/how-to-create-a-class-register/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 6 months ago](https://wordpress.org/support/topic/how-to-create-a-class-register/#post-12384619) * I totally understand; I’ll read through the help links and look forward to your video help. * Yes, I’ll have a dropdown menu for the teacher to select “present, absent or late”. The admin support will create unique attendance registers with a list of students selected in a similar manner as in your 1-2-many relationship videos( where you can select students to add to modules and courses), and then the tutor will edit the rows assigned to them and select present, absent or late. * But obviously, there’s the issue of timestamping each entry and ensuring that when a student/tutor logs in, they see only their attendance records in the table. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] How to autofill listbox columns from one table to another](https://wordpress.org/support/topic/how-to-autofill-listbox-columns-from-one-table-to-another/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 6 months ago](https://wordpress.org/support/topic/how-to-autofill-listbox-columns-from-one-table-to-another/#post-12384383) * Awesome! Thanks ever so much. I’ll update my plugin and try it out. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Creating logins using a WP Data Access table](https://wordpress.org/support/topic/creating-logins-using-a-wp-data-access-table/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 6 months ago](https://wordpress.org/support/topic/creating-logins-using-a-wp-data-access-table/#post-12367210) * Peter, it worked!!! * Many thanks for the advice. As I said, I’m in no way, shape or form an SQL programmer or dB designer and your instructions were enough to get me through. * Many, many thanks… * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Creating logins using a WP Data Access table](https://wordpress.org/support/topic/creating-logins-using-a-wp-data-access-table/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 7 months ago](https://wordpress.org/support/topic/creating-logins-using-a-wp-data-access-table/#post-12358967) * Thanks for the added help; all visuals and step-by-step instructions really do help as I’m not an SQL programmer in any way, shape or form. Love your app and it’s easy to get started. It’s easy to get the school data into the app. It’s just getting use to all the logic and terminology side of things. * I’ll try and understand what you’ve sent and see if I can get it working. Then will return and feedback. * Thanks ever so much! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Creating logins using a WP Data Access table](https://wordpress.org/support/topic/creating-logins-using-a-wp-data-access-table/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 7 months ago](https://wordpress.org/support/topic/creating-logins-using-a-wp-data-access-table/#post-12357308) * I’ve just raed the ‘id of the active user in WHERE Clause’ and the ‘User/student record for print?’ threads and watched a few tutorials about the $$USER$$ (video: Managing roles and user access). What I’m not understanding is how do I link the WP User to a row in my students table (or tutor or admin tables), please? So, if I have a WP user login called joe.bloggs and Joe Bloggs is in my student table, how do I link the two together so that all entries pertaining to Joe Bloggs is accessed when joe.bloggs logs in? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Foreign Key and how to create them](https://wordpress.org/support/topic/foreign-key-and-how-to-create-them/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 8 months ago](https://wordpress.org/support/topic/foreign-key-and-how-to-create-them/#post-12224810) * Brilliant! * The parent/child method in DATA PROJECTS works perfectly. It’s actually much easier to follow and really makes you think as to how to relate each column and table. * Many thanks * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Foreign Key and how to create them](https://wordpress.org/support/topic/foreign-key-and-how-to-create-them/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [6 years, 8 months ago](https://wordpress.org/support/topic/foreign-key-and-how-to-create-them/#post-12182638) * Oh I see, for the moment, we have to consider parent/child pages in substitute for foreign keys? * Would appreciate your help, of course. Should we PM on this occcasion? * Forum: [Themes and Templates](https://wordpress.org/support/forum/themes-and-templates/) In reply to: [[Semicolon] New SEMICOLON update has caused my posts and pages to disappear](https://wordpress.org/support/topic/new-semicolon-update-has-caused-my-posts-and-pages-to-disappear/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [11 years, 12 months ago](https://wordpress.org/support/topic/new-semicolon-update-has-caused-my-posts-and-pages-to-disappear/#post-5232486) * OK, I’ll do that and send you the log if that’s OK? I’ll do it tonight when access to the site has reduced and I can revert back to the semicolon theme. * I love your theme because it’s so simple, elegant and versatile. The text font was perfect for me. I can’t stand lily. It’s so blocky and box-like! * Forum: [Themes and Templates](https://wordpress.org/support/forum/themes-and-templates/) In reply to: [[Semicolon] New SEMICOLON update has caused my posts and pages to disappear](https://wordpress.org/support/topic/new-semicolon-update-has-caused-my-posts-and-pages-to-disappear/) * Thread Starter [Mushfiqur](https://wordpress.org/support/users/aa11plus/) * (@aa11plus) * [11 years, 12 months ago](https://wordpress.org/support/topic/new-semicolon-update-has-caused-my-posts-and-pages-to-disappear/#post-5232484) * My Web address is [http://www.birminghamshadhiliyatrust.org](http://www.birminghamshadhiliyatrust.org). I’ve changed the theme to lily temporarily because my friends and members are buying tickets and rooms to a charity Sufi event at the moment. But what I can tell you is that when I change the theme to other ones, and I preview, I get a preview. But when I revert to the semicolon theme and preview, nothing shows except my menu: no pages or posts show. Also, when I revert to semicolon and go into the dashboard, the page count in all pages is correct and the post count in all posts is correct but in neither can you see a list of posts or pages! Viewing 15 replies - 1 through 15 (of 15 total)