Is there a way or an existing query to retrieve all the participants registered details with their respective score and date of parcipation and export these data in excel sheet.
I have used the customs field to allow user to register their details like surname,name,age,country,email address.
All registered details are stored in the wp_wp_pro_quiz_statistic_ref table in form_data column as text.
To get the total score we must sum up the point values found in table
To retrieve the custom field name data we must use the table wp_wp_pro_quiz_form
My skill sql is not good that why am asking help to retrieve these data in the following EXCEL SHEET format
Thank you for your kind reponse and help
- The topic ‘Export registered participants data with their total score and date in excel’ is closed to new replies.