Thank you for the plugin. I do not know how to write SQL queries, and would like to use your plugin for producing some reports that are for the Current User’s activities on my site. I’m trying to produce a report that will show scores for quizzes that a user took.
Below is what I have so far which produced the saved report. It displays the report on my page but shows the report as “empty.” Would you be able to write me the proper query to use? answered, correct, and quiz are the columns in a table called ssquiz_users. I’d like to show this data for the Logged in user (just for the quizzes that they took). I appreciate any help you can provide.
SELECT answered, correct, quiz FROM ssquiz_users, wp_users WHERE user_name = ‘<?php $current_user->ID ?>’
- The topic ‘SQL query for current user Report’ is closed to new replies.