{source}
<?php
// Connect de database
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query =”SELECT title as titel, next as datum, hits FROM h29z1_icagenda_events ORDER BY next DESC”;
$db->setQuery($query); $db->execute(); $aantal=$db->getNumRows();
$results = $db->loadObjectList();
?>
</h2><p class=”signaal”></p>
<table class=”table table-striped”>
<tr><td><H3><b>Evenementen</a></td><td><H3><b>Datum/tijd</td><td><H3><b>Hits</td></tr>
<?php
// Toon de gevonden gegevens
foreach($results as $result){
echo”<tr><td>” . $result->titel . “</td><td>” . $result->datum .”</td><td>” .$result->hits .”</td></tr>”;
}?>
</table>
{/source}
{pagebuilderck 15}