$sql = "SELECT * FROM gamingcontest ORDER BY RegistrationDate ASC"; $result = $db->query($sql); while ($row = $db->fetch($result)) { ?> <div class="columns two"> <div class="person"> <p class="italic"><?php echo $row['Name']; ?> </p> <p class="info"><span class="bold">ID:</span> <?php echo $row['StudentID']; ?> </p> <p class="info"><span class="bold">Batch:</span> <?php echo format_position($row['Batch']); ?> </p> <p class="info"><span class="bold">Department:</span><br><?php echo $row['Department']; ?> </p> <div class="icons" style="width: 106px"> <div class="icon32x32 n17" title="<?php echo $row['ContactNo']; ?> "></div> <div class="game32x32 <?php echo $row['Game']; ?> " title="<?php
?> </div></div> <div class="row"><div class="columns six left">Email: </div> <div class="columns six right"><?php echo $Member->getEmail(); ?> </div></div> <div class="row"><div class="columns six left">Student ID: </div> <div class="columns six right"><?php echo $Member->getStudentID(); ?> </div></div> <div class="row"><div class="columns six left">Department: </div> <div class="columns six right"><?php echo $Member->getDepartment(); ?> </div></div> <div class="row"><div class="columns six left">Batch: </div> <div class="columns six right"><?php echo format_position($Member->getBatch()); ?> </div></div> <div class="row"><div class="columns six left">Admission: </div> <div class="columns six right"><?php echo $Member->admission(); ?> </div></div> <div class="row"><div class="columns six left">Club User ID: </div> <div class="columns six right"><?php echo $Member->getUserID(); ?> </div></div> <div class="row"><div class="columns six left">Joining Date: </div> <div class="columns six right"><?php echo formatDate($Member->getJoiningDate()); ?> </div></div> </div>