Table with child rows from mysql table

I have a Mysql table, from which, using plugin called DataTables, I create a table on my Wordpress website. So basically I fetch a table with 10 columns and 300-400 rows. I want to understand how to fetch two more columns from SQL, let's say "price" and "salary", and insert those into child rows. I have seen some examples on the website but they seem either too complex for me or not suitable for SQL data. My current table is not using AJAX nor JSON to fetch data, I just make a query to sql, fetch results and input them into a table using something like "while ($queryRow = $queryResult->fetch_row()) {

echo "<tr>";

for($i = 0; $i < $queryResult->field_count; $i++){

echo "<td>$queryRow[$i]</td>";"

Reference for what I want to see: [login to view URL]

If it's not possible to do child rows using my current table's format, it's okay to change it if you explain me how to use it. Please consider that I'm using Wordpress and my webdev skills are not impressive. Thank you in advance!

Taidot: PHP, MySQL, WordPress, Datatables, JavaScript

Näytä lisää: php mysql table user, mysql table structure dump, joomla image mysql table, counting entrie mysql table, display mysql table, getafreelancercom grab web data mysql table, php script save checkbox status mysql table, create mysql table form data, import rows mysql table, drop menu mysql table rows, simple table mysql data wordpress plugin, mysql table parent child lowest level, sobi2 gallery plugin mysql table, delete all rows from table mysql, mysql limit number of rows in table, how many rows can mysql table handle

Tietoa työnantajasta:
( 0 arvostelua ) Moscow, Russian Federation

Projektin tunnus: #31904117

6 freelanceria on tarjonnut keskimäärin $36 tähän työhön


Hello. WordPress development expert ready to help you with a project. I have more than 400 good reviews and more than 9 years of development experience behind, so all job will be done with the best quality and timefram Lisää

$50 USD 1 päivässä
(637 arvostelua)

Hello Sir Can we discuss the job in details? I am willing to start right away Please check my profile for work and experience. Regards Ashwin

$70 USD 1 päivässä
(355 arvostelua)
(58 arvostelua)

Hello Client, I am an expert in WordPress, PHP / MySQL, JavaScript/JQuery, CSS and HTML. I can do the specified task . Thanks! Satyajeet

$30 USD 1 päivässä
(147 arvostelua)

Hi, there. As a web developer, I've been developing for over 5 yrs. We can discuss more details and work together. Thanks.

$20 USD 7 päivässä
(2 arvostelua)

Hello sir My name is Umakant Yadav I have 3 years experience in core PHP , Codeigniter and WordPress , webhosting, mysql , Shopify SSL instalation html5 Domain redirection, Using Jquery , Ajax. My recent projects Lisää

$15 USD 7 päivässä
(3 arvostelua)