使用php获取行/列中的数据

Question

I want to make 4 columns in table. In code all the images are comes in single row and single column. But I want a single row containing 4 columns with 4 images (images fetching from database), then create another row and automatically add next 4 images & so on. I don't know how I do this can anyone please suggest me how I do this.

  <form name="form">
    <select id="sorting" style="width:140px" onChange="optionCheck()">
      <option id="s">---Sort By----</option>
      <option value="bydate">Sort By Date</option>
      <option value="bytopic">Sort By Topic</option>
    </select>
  </form>
  <br />
</div>

<?php include 'connection.php'; ?>

<div id="showByDefault">
  <table style="width:60%">
  <tr>
    <?php   include 'connection.php';  ?>
<div id="showByDefault">
<!--<table style="width:60%"><tr>-->


 <?php
      $sql1=mysqli_query($con,"select * from `insert-n-retrive-pdf` ORDER BY date DESC") or die(mysqli_error($con));
      $i=0;
      echo "<table><tr>";

  while($row=mysqli_fetch_array($sql1))
  { 
   if($i != 0 && $i%4 == 0) {
        echo '<tr></tr>';
    }
    ?> <td style="padding:20px;">


     <a href="<?php echo $row["path"]; ?>" target="_blank"><img src="<?php echo $row["thumbnails"]; ?>" /></a></td><?php

        echo '</tr>';
    $i++;
  }   
?></tr></table>
</div>

<div id="hideall">
    <div id="topic1">
      <?php include 'pdf-sort-by-topic.php'; ?>
    </div>

    <div id="topic">
      <?php include 'pdf-sort-by-date.php'; ?>
    </div>
</div>

Answer 1

Try this one 100% working: Nice and easy.

    <?php

            $sql1=mysqli_query($con,"select * from `insert-n-retrive-pdf` ORDER BY date DESC") or die(mysqli_error($con));
            $i = 0;
            echo "<tr>";
            while($row=mysqli_fetch_array($sql1)) { 
                if($i != 0 && $i%4 == 0) {
                    echo "</tr><tr>";
                }

    ?>          
                <td style="padding:20px;"><a href="<?php echo $row["path"]; ?>" target="_blank"><img src="<?php echo $row["thumbnails"]; ?>" /></a></td>
    <?php       
                $i++;
            }
    ?>

Hope this helps!