As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1686317
dropdown list connecting to database
Closed

Comments

  • Craig Doriot started the conversation

    I am trying to figure out if this plugin will work for my needs.  I have a data table that I want users to edit the fields, driven by a Mysql query.. so the user would click to edit the row and up would show a dropdown or select box with ID/value pair.  They can edit the field inline and it would update the row with the new ID in the database.

  • [deleted] replied

    Hi Craig,
    Thank you for your inquire.

    We do have editable tables created from MySQL query - Documentation

    and you can configure it to have dropdown as editor input type - Documentation

    If you need to show one information in column and other to be saved you can take a look at foreign key option - Documentation

    For testing purpose we have sandbox website where you can see and test all plugin functionalities

    sandbox.wpdatatables.com

    username: demo

    password: demo