I am having problem to the footable because whenever i use the data-format-string in footable the output becomes the same.
<table id="table" data-paging="true" data-sorting="true">
<thead>
<tr>
<th data-name="date_from" data-type="date" data-format-string="MMM DD YYYY">Date</th>
<th data-name="title">Title</th>
<th data-name="venue">Venue</th>
<th data-name="activity_id">View</th>
</tr>
</thead>
<tbody>
<?php
$myqry=$db->prepare("SELECT activity_id,date_from,title,venue FROM activity" );
$myqry->execute();
$anotherarray=array();
while($myqr=$myqry->fetch(PDO::FETCH_ASSOC)){
echo '<tr><td>'.$myqr['date_from'].'</td>
<td>'.$myqr['title'].'</td>
<td>'.$myqr['venue'].'</td>
<td><a href="view_act.php?actvid='.$myqr['activity_id'].'">View</a></td></tr>';
}
?>
</tbody>
</table>
What I expect:
What I get: