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!
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 timeframe.
Free bug fixing support.
We can always make deal on price.
Tnx, and hope to hear you soon.