$posts = new posts();
include_once 'model/functions.php';
$f = new db_functions();
?>
<div id="leftnav">
<h3>Categories</h3>
<ul>
<?php
$categories = $posts->categories_array();
foreach ($categories as $id => $name) {
echo "<li><a href='?page=categories/" . $name . "'>" . $id . "</a></li>";
}
?>
</ul>
</div>
<div id="leftnews">
<h3>Popular news</h3>
<ul>
<?php
// $sql=select("news", array("id","name","category_id"), NULL,array("views","DESC"), 5);
// $sql=$posts->view_news(array("id","category_id","name"), false, array("views","DESC"), 5);
$sql = $f->select("news");
while ($rows = mysqli_fetch_array($sql)) {
echo "<li><a href='showpost.php?news=" . $rows['id'] . "'><img src='images/slide-2-86x86.jpg'></a>\n <div class='cont_2'><a href='showpost.php?news=" . $rows['id'] . "'><h5>" . $rows['name'] . "</h5><br></a>" . $categories[$rows['category_id']] . "</div></li>";
}
?>
</ul>
<a href="Registry.php">See all</a>
</div>
</div>