emiliolorenzo30 0 Newbie Poster
                                        $sql = "SELECT cl_id, cl_name, cl_service_description, cl_contact, cl_dept,status, expiry_date from contract_list";
                                        $result = $conn-> query($sql);

                                        if($result->num_rows > 0)
                                        {
                                            while($row = $result-> fetch_assoc())
                                            {
                                                  echo "<td>$row[cl_id]</td>";
                                                  echo "<td>$row[cl_name]</td> ";
                                                  echo "<td> $row[cl_service_description]</td>";
                                                  echo "<td>$row[cl_dept]<td>";
                                                  echo"$row[status]";
                                                  echo "<td>$row[cl_contact]</td>";
                                                  echo "<td>$row[expiry_date]</td>";
                                                  echo "<td></td>";
                                                  echo "<td><div class=table-data-feature>";
                                                      echo "<button class='item' data-toggle='tooltip' data-placement='top' title='send'>";
                                                          echo "<i class='zmdi zmdi-mail-send'></i>";
                                                      echo "</button>";
                                                      echo "<button class='item' data-toggle='tooltip' data-placement='top' title='Edit'>";
                                                          echo "<i class='zmdi zmdi-edit'></i>";
                                                      echo "</button>";
                                                      echo "<button class='item' data-toggle='tooltip' data-placement='top' title='Delete'>";
                                                          echo"<i class='zmdi zmdi-delete'></i>";
                                                      echo "</button>";
                                                      echo "<button class='item' data-toggle='tooltip' data-placement='top' title='More'>";
                                                          echo"<i class='zmdi zmdi-more'></i>";
                                                      echo"</button>";
                                                  echo "</div>";
                                              echo "</td>";
                                                  echo "<tr class=spacer></tr>";

                                            }
                                        }
                                            ?>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.