Title: table configuration
Last modified: August 22, 2016

---

# table configuration

 *  Resolved [massimo86massimo](https://wordpress.org/support/users/massimo86massimo/)
 * (@massimo86massimo)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/table-configuration/)
 * Hello,
    I have a problem with the table structure (cf7dbplugin_submits in database).
 * I need to load fields in Contact Form 7 with the values of fields already insert(
   if they exist), and I would take them directly from the database in the table
   used to storage them via phpMyAdmin (cf7dbplugin_submits).
 * My problem is here. There is one row for field, instead I would have one row 
   for all the fields of the specific Form.
 * I need to have each fields in the columns of table, and I wouldn’t have a column
   named “name_field” with the name of the specific field, and an other column named“
   value_field” with the value of that field.
 * I hope to have been clear. This because I have to catch all the fields with some
   specific value in a key field..
 * Thank you so much..
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/table-configuration/#post-5254132)
 * I don’t clearly understand what you are asking. You can create a MySQL “VIEW”
   that makes the data appear as one row per submission. (The same as it appears
   in the administration page).
 * – In the CFDB Options page, set “Show the query used to display results” to “
   true”
    – Navigate to your form results in the administration page – Copy the 
   query that appears there – In MySQL execute: “CREATE VIEW your_form_name ” followed
   by the query. – Then you can query your_form_name as a table. (But you can’t 
   load data).
 * I don’t know if that answers your question.
 *  Thread Starter [massimo86massimo](https://wordpress.org/support/users/massimo86massimo/)
 * (@massimo86massimo)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/table-configuration/#post-5254250)
 * Perfect! Thank you so much

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘table configuration’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

## Tags

 * [table](https://wordpress.org/support/topic-tag/table/)

 * 2 replies
 * 2 participants
 * Last reply from: [massimo86massimo](https://wordpress.org/support/users/massimo86massimo/)
 * Last activity: [11 years, 8 months ago](https://wordpress.org/support/topic/table-configuration/#post-5254250)
 * Status: resolved