$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>
