<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <link rel="stylesheet" href="main1.css">
    <link rel="stylesheet" href="/css/master.css">
    <link rel="stylesheet" href="form.css">
     <link rel="stylesheet" href="jquery.css">
    <link rel="stylesheet" href="../tableview.css">
    <title>view All Attendees</title>
  </head>
  <body>
    <?php
    
    require "../includes/database.php";





    // echo "Haha.. Connected successfully";
    $sql = "SELECT *
    FROM NewMember WHERE NewMemberAdjusted Like '%No%'
   " ;

    $results = mysqli_query($conn, $sql);

    if ($results === false) {
      // code...
      echo mysqli_error($conn);
    } else {
      // code...
      $viewGuests= mysqli_fetch_all($results, MYSQLI_ASSOC);



    }

     ?>
     <div class="field">



      
      <h2><center>New Member Application</center></h2>

           <?php if (empty($viewGuests)):?>
             <p>No New Member  found</p>
           <?php else: ?>
           <ul>
             <?php foreach ($viewGuests as $Guest):  ?>
            <div class="field">


             <table id="Guests">
               <tr>
                 <th>First Name</th>
                 <th> Last Name</th>
                 
               </tr>

               <tr>
                 <td><a><?= $Guest['NewMemberFirstName'] ?></a></td>
                 <td><?= $Guest['NewMemberLastName'] ?></td>
                 
               </tr>
             </table>
           <?php endforeach; ?>
           </ul>
         <?php endif; ?>

        
         </div>
         </div>


  </body>
</html>
