"7e0d40de-bb8a-4da0-9cc4-858e1dbcc72c" (#1443011) / TMS-Plugins

Comments

certiprof started the conversation
January 23, 2018 at 8:21pm
I have a query, I have two mysql tables “link_results” and “test” with wpData Tables I want to show “link_results” on a page of my website.

Both tables have a column called “test_id” which is a data number, but in the table “test” that data number is assigned a name in a second column. In other words, each ID has a name.

I want to show in my final table “link_results” the name of that ID that is in the “test” table. How can I do this?

Thanks for your help.
certiprof replied
January 23, 2018 at 8:23pm
I have a query, I have two mysql tables “link_results” and “test” with wpData Tables I want to show “link_results” on a page of my website.

Both tables have a column called “test_id” which is a data number, but in the table “test” that data number is assigned a name in a second column. In other words, each ID has a name.

I want to show in my final table “link_results” the name of that ID that is in the “test” table. How can I do this?

Thanks for your help.
472
Isidora replied
January 24, 2018 at 10:15am
HI certiprof,
Thank you for your purchase.
My suggestion is to look up in our documentation about Configuring table relations (foreign key).
Kind Regards,

Isidora Markovic

wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs

You can try our wpDataTables add-ons before purchase on these sandbox sites:

Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
1 Like