Dependable and multi selection tables
Dependable and multi selection tables
Hi everyone,
I'm new to datatables and I'm afraid I need a kick start here.
I wanna use datatables to retrieve and display data from my database. In that database, to keep things simple, let's say I have a table "Continent", a table "Country" and a table "State". On my webpage, I managed to create the first datatable, displaying the data from the database's table "Continent". Now, every time a user select a row (it's a multi selection datatable) on that datatable, I'd like to feed a second datatable that would display the Countries stored in the database's table "Country" that belong to the selected Continent(s), then feed a third datatable displaying the States.
I can see it will involve Ajax and SQL but I can't get started. Could anyone provide a code that would get me jump started? I feel that if I had an exemple, I could take it from there
Much appreciated
This question has an accepted answers - jump to answer
Answers
This blog about parent / child tables should get you started:
https://datatables.net/blog/2016-03-25
Kevin
Thank you Kevin