Datatables Child Rows with data from mysql database

yogibear

Hi

I want to use the rows functionality as shown here https://datatables.net/examples/api/row_details.html

But i need to be able to populate the rows with data from a mysql database query. I cant figure out how to do this.
Also the child rows would come from the database, and be multiples of the same types.

Basically I am trying to list orders in the parent row (order no, date, value), and then the child rows would be the items in the order - so multiple rows of product no, description, qty etc.

I can pull all the data from the database no problem, but can anyone assist with how i would handle using data table child rows?

thanks