title: Refresh data without loading page php sql
body: <p>I have an HTML table and PHP for it to process and show in HTML table. It get's refreshed everytime page is loaded but I want to auto-refresh every 1 second. Heres  PHP:-</p>
  
  <pre><code>    $seql = "select price, sum(total), sum(aleft) from trade where status = 'active' and bm = '$bm' and m = '$market' and type = 'sell' group by price";
       $query100 = mysqli_query($conn, $seql);
  </code></pre>
  
  <p>And html table</p>
  
  <pre><code>  &lt;div style='float: left;'&gt;
  &lt;br&gt;&lt;br&gt;
  &lt;p style="padding-left:16px; font-size: 20px;"&gt;Amount(&lt;?php echo $market; ?&gt;) | Price(&lt;?php echo $bm; ?&gt;) &amp;nbsp | Total(&lt;?php echo $bm; ?&gt;)&lt;/p&gt;
  &lt;div class="panel-hello scrollbar" id="style-11"&gt;
      &lt;div class="data-table"&gt;
          &lt;table class="table table-hello table-bordered table-hover force-overflow" id="btcaddresses"&gt;
              &lt;tbody style="border: 1px solid green; height: 300px; overflow-y: scroll;"&gt;
                  &lt;?php
      while ($row = mysqli_fetch_array($query100))
      {
          echo '&lt;tr style="cursor: pointer; font-size: 15px;"&gt;
                  &lt;td&gt;'.number_format($row['sum(aleft)'], 8).'&lt;/td&gt;
                  &lt;td&gt;'.number_format($row['price'], 8).'&lt;/td&gt;
                  &lt;td&gt;'.number_format($row['sum(total)'], 8).'&lt;/td&gt;
              &lt;/tr&gt;';
      }?&gt;
              &lt;/tbody&gt;
          &lt;/table&gt;
      &lt;/div&gt;
  &lt;/div&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p>Help is appreciated .</p>