限制查询结果

Question

This is my code..

<table>
                    <tr>
                        <th>Sun</th><th>Mon</th><th>Tue</th><th>Wed</th>
                        <th>Thu</th><th>Fri</th><th>Sat</th>
                    </tr>

                    <tr>

                    <?php
    require("conn.php");
    $query = "SELECT * FROM temp WHERE id != (SELECT MAX(id) FROM temp)";
    $result = mysqli_query($con,$query);


    while($line = mysqli_fetch_array($result))
    {

     echo "<td>$line[4]<table><tr><td> $line[1]</td><td> $line[2]</td></tr></table></td>";


                    }
                    ?>

                    </tr>


                </table>

Now I am displaying only 7 records for only one week. I want to display first 7 records in first row and second 7 record in second row and so on..So how do I do that in my code. I am making changes but chages design and I dont want to change the design.

With above code result is like following ..

I want to display only 7 records up to saturday and next 7 records in next row..

Answer 1

<table>
                    <tr>
                        <th>Sun</th><th>Mon</th><th>Tue</th><th>Wed</th>
                        <th>Thu</th><th>Fri</th><th>Sat</th>
                    </tr>

                    <tr>

                    <?php
    require("conn.php");
    $query = "SELECT * FROM temp WHERE id != (SELECT MAX(id) FROM temp)";
    $result = mysqli_query($con,$query);
    $i=1;

    while($line = mysqli_fetch_array($result))
    {
       echo "<tr>";
         if($i<=7){
                  echo  "<td>$line[$i]</td>";
                  $i++;   
                   }
           echo "</tr>;
     }

           //condition for next week 
                $i=0;
     ?>      
    </tr>
                </table>