title: PHP/database table loop - display only 15 rows at time
body: <p>I have a database I'm trying to display for edit through PHP. On the main page I want to show only the first 15 rows of the table then have the user click to generate more table rows.</p>
  
  <pre><code>&lt;?php 
  include('../config.php'); 
  $result = $mysqli-&gt;query("SELECT uid, title, description, tblFacilityHrsDateTimes.* FROM tblFacilityHrs LEFT JOIN tblFacilityHrsDateTimes ON tblFacilityHrs.uid = tblFacilityHrsDateTimes.owner_uid ORDER BY tblFacilityHrs.title") or die($mysqli-&gt;error);
      while($row =$result-&gt;fetch_assoc()){ 
          extract ($row);
          echo "&lt;tr&gt;";  
              echo "&lt;td&gt; {$id} &lt;/td&gt;";  //hide when finished
              echo "&lt;td&gt; {$title} &lt;/td&gt;"; 
              echo "&lt;td&gt; {$description} &lt;/td&gt;";
              echo "&lt;td&gt; {$startEventDate} &lt;/td&gt;";
              echo "&lt;td&gt; {$endEventDate} &lt;/td&gt;";
              echo "&lt;td&gt; {$startTime} &lt;/td&gt;";
              echo "&lt;td&gt; {$endTime} &lt;/td&gt;";
              echo "&lt;td&gt; {$days} &lt;/td&gt;";
              echo "&lt;td&gt; {$recurrence} &lt;/td&gt;";
              echo "&lt;td&gt; {$finalDate} &lt;/td&gt;";
              echo "&lt;td&gt;";
              echo "&lt;a class=\"buttons\" href=edit.php?id={$id}&amp;uid={$uid}&gt;Edit&lt;/a&gt;&lt;span class='icon'&gt;&lt;/span&gt;&lt;/a&gt;
  ";
              echo " / ";
              echo "&lt;a class=\"buttons\" href='javascript: Confirm()'&gt;Delete&lt;/a&gt;";
              echo "&lt;/td&gt;";
          echo "&lt;/tr&gt;";
          echo "&lt;/div&gt;"; 
      } 
  
  echo "&lt;/table&gt;";
  
  $result-&gt;free();
  $mysqli-&gt;close();
  
  ?&gt;
  </code></pre>