title: get table name from count query
body: <p>How do you get table name from count query, I have multiple queries and I need to get table name from the query results, here is my query</p>
  
  <pre><code>$myquery = "select count(tb_id) as num_rows from table1; select count(tb1_id) from table2...";
  if (myqli_multi_query($connection, $myquery){
  ..
  $row = mysqli_fetch_assoc($result);
  $num_rows = $row["num_rows"];
  ..
  }
  </code></pre>
  
  <p>The query is working fine as I can get the number of rows, but I am unable to link the table name to the number of rows (result)</p>
  
  <p>I have tried this, which executes without error, but unable to get the table name still</p>
  
  <pre><code>select count(tb_id) as num_rows, 'table1' as TableName from table1
  </code></pre>